Dan Murphy's Blog

For those who have had to move wordpress you probably have found it a little tedious as there is no quick way to pick it up and move to another server.  Well I have moved a bunch of sites from my development server to their respective production environments so I have the process down.  Below is a checklist of how to move from server to server.

1. Move all the files from the WordPress directory to the main server (I find it easier to zip everything the transfer that one file and then unzip on the server)
2. Edit the wp-config.php file in the root folder to have the correct connection information on the new server
3. Dump the database to a file using the mysqldump command (See Post)
4. Re-import the dumped data file to the new server using the mysql command (See Post)
5. Log into the production server and run the following two SQL lines:
   1. update wp_posts set post_content = replace(post_content,’DEVSERVERURL‘,’PRODSERVERURL‘);
   2. update wp_options set option_value = replace(option_value,’DEVSERVERURL‘,’PRODSERVERURL‘);
6. Log into WordPress Admin and double check all the general settings (if you use nextgen you have to re-input everything manually)
7. Turn off your Dev server (This one is key so you know that you can see if you have any image or anything references pointed back to your old server)