Home » Experts Only » Updating WordPress Database After Website Move

Updating WordPress Database After Website Move

Boy life sure would be easy if WordPress used relative URL’s throughout the menu and post content but that simply isn’t going to happen, they’ve made that clear. Changing the URL in the admin Settings would then be all you need to do, making moving installations a breeze. Not the case, we should stop crying about it.

There are a few plugins that will migrate WordPress without much fuss. Our favorite is All in One Migrate. The free version only allows migrations of 500MB or less.

If you’re forced to do a manual transfer, all you’ll need is a couple additional steps. We’ll assume you changed the URLs in your admin settings. Now simply log into your hosting cpanel and get to PHPMyAdmin, then find your database. If you need your database name then head over to your file manager and locate the wp-config.php file in the website’s main directory. It’s there under db_name.

Once you’ve located your website’s database in PHPMyAdmin, select SQL (see image below) to enter the following statements, replacing the new and old URL’s with your values. Be sure the table names match up, yours may have the prefix wp_, or more likely something like wp_123_. Just be sure the table names match when you execute this SQL. Be sure you’ve updated your wp_options table – this is already updated if you changed the URL in your admin Settings.

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

wordpress change url database

More Web Design Blog Content

New Website for NWSF!

Northwest Seafood got hacked unfortunately. Being previous clients of ours we came to the rescue. The site was damaged beyond repair so our team of Gainesville Web Design experts took hold and gave them a brand new website in a matter of days. We always support our clients in

Maintaining Correct Site Structure

One of the biggest holes in a client’s SEO (pre livewire SEO, that is) is almost always the site structure. So many SEO companies focus on content and backlinks that quality code is often overlooked. There are many cases where we have come into the tail end of

To Gimp or Not To Gimp

In the world of photo editing, adobe photoshop is king. They really do have an amazing product. It’s sleek, works great, and is very robust sporting dozens and dozens of functions and endless possibilities for the graphic artist.  Photoshop is also very, very expensive. The entire Adobe creative

New Beginnings: Mcgriff WIlliams Insurance

New clients start today: Mcgriff Williams Insurance has decided to start a new campaign for online insurance quotes. We’ll be providing a key marketing role with their new website: INSURENCY.com They have the very latest in online quotes and are attempting to break into a heavily saturated market

Woocommerce Products Per Page

Interestingly Woocommerce does not seem to have a default setting for ‘products per page’. Unsurprisingly, there’s a simple workaround. Add to your functions.php Replace “28” with whatever number you want. add_filter( ‘loop_shop_per_page’, create_function( ‘$cols’, ‘return 28;’ ), 20 );