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 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
