Moving WordPress hosts from dev to prod for Clearlake Auto Service

This afternoon, I’m working on moving the development instance for a client from my test server to his host provider, cBeyond. The first thing I did was to back up his existing site with FileZilla to my local hard drive. I then went into phpMyAdmin on his host site and backed up his existing WordPress database instance.

I then went into MySQL Workbench on my development server and exported the WordPress Schema. I then imported the database Schema into the host provider using phpMyAdmin. Next, I used FileZilla to upload all the WordPress site files from my development server to the cBeyond host server. This took about 15 minutes to complete.

I then logged back into phpMyAdmin, and ran the following sql query:

select * from wp_options

I then edited the results for option_name = ‘home’ to ‘http://www.clearlakeautoservice.com’. I also edited the results for option_name = ‘siteurl’ to same.

Continued on 5/12/2010…

Next, I copied the wp-config.php from the original WordPress site on the host provider to my local hard drive. I updated the new wp-config.php file and changed the following entries:

// ** MySQL settings – You can get this info from your web host ** //
/** The name of the database for WordPress */
define(‘DB_NAME’, ‘********’);

/** MySQL database username */
define(‘DB_USER’, ‘********’);

/** MySQL database password */
define(‘DB_PASSWORD’, ‘********’);

/** MySQL hostname */
define(‘DB_HOST’, ‘localhost’);

I next went into phpMyAdmin and granted all privileges the new WordPress database to the existing DB_USER used above.

I am now able to pull up the new site Clearlake Auto Service. I’m not done yet. Now, I need to update the perma-links. I logged into the WordPress site and navigated to Settings | Permalinks. I then toggled from Day and name to Default and clicked Save Changes. I then put it back to Day and name and clicked Save Changes.

Leave a Reply