Larry Brouwer

... just my personal technology sandbox

  • About
  • Blog
  • Archives
  • Contact

Connect

  • Email
  • Facebook
  • LinkedIn

Powered by Genesis

Moving WordPress hosts from dev to prod for Clearlake Auto Service

May 11, 2010 By Larry Brouwer Leave a Comment

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.

Filed Under: Daily Log Tagged With: WordPress

Leave a Reply

You must be logged in to post a comment.

Recent Posts

  • Weaver’s Bamboo “Bambusa textilis” clumping bamboo for sale
  • configuring NTP Service on FreeNas, XenServer, and virtualized Windows Server 2012 R2 Domain Controller
  • CentOS 7 Warning: Your Magento folder does not have sufficient write permissions.
  • AOE Scheduler 1.3.0 cron issue with Magento 1.9.2.2

Tag cloud

SVN Database Mail Yahoo Mail .NET Framework PST Blogs redirect Security mstsc.exe Google Analytics SSL SMTP D-Link BlogEngine.Net SSMS TomatoCart Exchange 2010 SmarterMail MySQL Scanpst.exe clumping bamboo Windows 7 Outlook Connector Port 25 AWStats Maytag PHP ASP.Net web.config Spam Comcast Log Parser SBS2011 DotNetNuke Neptune Live Writer Silverlight Azure SqlServer Tools OpenCart C# Linux WordPress Outlook 2007