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

No Business is too Small for Mobile

No matter how small your business is, you need to be on mobile. There are more mobile users these days than traditional desktop/laptop users, so the benefit is apparent. If your website is not mobile ready, you are at a distinct disadvantage. First, the user will probably have

The Amazon Dams Network

Proud to present the first online version of the Amazon Dams Network. This has been a project Livewire has been working on for several months with the University of Florida and other members from around the world. This has been a very exciting project and we are pleased

web design ocala fl

Why Local Web Design Matters for Your Ocala Business

In today’s digital age, having a professional website isn’t just an option—it’s a necessity. But not all websites are created equal, especially when it comes to local businesses. If your business is based in Ocala, FL, choosing a local web design company like Livewire can make all the

SEO Update: American Metals

Since SEO is our specialty – we know what it takes to put a website on page 1. When American Metals came to us they were back past page 10 for a lot of their keywords and getting about 50 users per month on average on the website.

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

Are You Using Linkedin Like You Should?

Probably not. Linkedin is a valuable resource for any professional, but particularly freelancers and business owners. There is a lot to love about the social media construct, and a lot to hate; but no matter what side of the coin you fall on it is no secret that you