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

Domain names other than .com a good idea?

Top Level Domains (TLDs), which are suffixes, are the final part of URLs. Although.com is well-known, there are more than 1,000 TLD choices available; however, not all of them are open to the general public. Prior to TLDs, IP addresses were used to visit websites, however this proved

Florida Auctioneers Has A New Website

Proud to present the new and improved Florida Auctioneers Association Website! This was a lengthy project but the final website is well worth it. Really more of a web portal, the system is chock full of features and runs smooth and fast. The site features: Membership program Member

Getting Accurate Shipping Rates

If you own an ecommerce store and provide real time shipping rates you have likely encountered a long list of issues with returning accurate rates. If you have not, Bravo good sir or madam! You are the exception. Having real-time shipping rates on your online store is a

What You Should be Asking

When hiring a developer, many people don’t know what questions they should be asking – if they knew, then they’d probably be doing the work themselves, right? First and foremost – ask for examples of previous projects. The surefire way to weed out the novices is to look

Fraternity Management Has a New Website

Fraternity management needed something up quickly and something that was affordable. Glad to know that they chose us as their Gainesville Web Design team.  Additional to the website they requested a simple program that managed their payment modules. As experienced PHP developers, we were able to quickly put

2 Great Marketing Funnel Tools

Using Outbase for Target Market Research With Outbase’s multitude of capabilities, you can gain a deeper knowledge of your sales performance and identify areas for improvement. Outbase is a prospecting platform that streamlines the top funnel challenges experienced by business-to-business organizations. Thanks to a large dataset covering numerous