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

You get 15 seconds! Web Design Trends for 2016

Mobile is in and users are becoming increasingly impatient. In 2014, 55% of users spent less than 15 seconds on a webpage according to data by Tony Haile of Chartbeat.  This means you only have 15 seconds to capture a users attention and convert a visitor to a customer.

WordPress Email Issues

Every now and again we run into issues with WordPress where the email functionality has stopped working. This is usually the result of corrupted core files and/or plugin conflicts. Easy enough to fix: disable plugins or upload a fresh copy of the software and you’re good to go.

The Flour Pot Bakery has a new website.

NEW!! Sally is one of a kind and so is her business. She really takes the time to put out a quality product and we wanted to give her that same high quality standard with her website that she is used to. FPB has some fantastic bread –

TOP 3 PROJECT MANAGEMENT TOOLS AND WHY THEY ARE SO IMPORTANT

Whether you are a Freelancer or a small business owner, you know the importance of an accurate project management, here are 3 of the best project management tools that can help you achieve your goals. 1.- Teamwork Projects Teamwork Projects is a cloud-based project management solution it allows you

Gainesville Website Design: Mobile Websites

Mobile sites are a great way to tap into a new resource for many businesses. More and more people are using their phones as their primary device for Internet access. Phones are more computers than they are phones these days. A mobile website is a lightweight version of

Local Search Listing Management on Google

Building a strong customer base in your local community has always been one of the most significant components in the success of a business. With over 50% of Google searches completed on mobile devices, it’s more important than ever that on-the-go users can locate your business fast through