Here is my list of tasks to do to move a ee site to a new server and domain. It is not exhaustive!
1. Copy folders with php and html
Copy using ftp or scp.
zip -r ee_seeds.zip *
scp ee_seeds.zip user@newserver:/path
2. Move Database
Dump database to sql file and copy to new server. Create new database and upload sql file then create new user.
login old server
mysqldump—opt -u root -p ee_seeds>seeds.sql
scp seeds.sql user@newserver:/path
login new
mysql> create database ee_seeds
mysql -u root -p ee_seeds<ee_seeds.sql
mysql>grant all privileges on ee_seeds.* to ee_seeds@localhost identified by ‘xyz’;
3. Update domain names and paths in database
In MySQL:
update exp_templates set template_data= replace(template_data,‘seeds.pigmightfly.com’,‘www.brownenvelopeseeds.com’)
update exp_weblogs set blog_url=replace(blog_url,‘seeds.pigmightfly.com’,‘www.brownenvelopeseeds.com’)
update exp_weblogs set comment_url=replace(comment_url,‘seeds.pigmightfly.com’,‘www.brownenvelopeseeds.com’)
update exp_weblogs set search_results_url=replace(search_results_url,‘seeds.pigmightfly.com’,‘www.brownenvelopeseeds.com’)
update exp_categories set cat_image=replace(cat_image,‘seeds.pigmightfly.com’,‘www.brownenvelopeseeds.com’)
update exp_upload_prefs set url=replace(url,‘seeds.pigmightfly.com’,‘www.brownenvelopeseeds.com’),server_path=replace(server_path,’/home/pigmightfly.com/seeds/’,’/hsphere/local/home/brownenv/seeds/’);
Update config.php
* replace urls and paths
* change webmaster email
* change mysql settings if required
* xinha image settings in xinha/plugins/ImageManager/config.inc.php
4. In Control Panel
* Modules, Gallery, Preferences - change all paths and URLs
Another method
See this kb entry
