x
 
Create New Page

Revision: Moving Servers

Revision from: 04:35, 10 Apr 2007

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

Categories: