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

PrestaShop Maytag Magento SmarterMail MySQL Windows 7 CentOS SqlServer Live Writer iframe Silverlight mstsc.exe Blogs eCommerce .NET Framework Yahoo Mail BlogEngine.Net D-Link Comcast Linux SSMS Windows Remote Desktop SBS2011 PST Visual Studio Database Mail Outlook 2007 Neptune SMTP AWStats Spam Tools 301 Exchange 2010 Scanpst.exe Outlook Connector PHP Google Analytics ASP.Net Security Azure DIR-655 SSL redirect OfficeLive