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

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.

Don’t Think Page Load Times Matter? Think Again.

A recent study by Google really hit home for online retailers or anyone looking to make a sale/conversion online. As Forbes points out: “53% of mobile site visitors will leave a page that takes longer than three seconds to load.” Google’s recommendations usually hover around one to one

Minimalism in Design

By eliminating clutter and concentrating on essential features, minimalist web design prioritizes user experience. This method prioritizes an uncomplicated and aesthetically pleasant user experience by utilizing clean lines, plenty of white space, and a minimal color palette. Minimalist websites accomplish these goals by reducing unnecessary design features, which

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

Offline linking

This is a profound point. A lot of linking takes place offline. Sounds weird but many great links sprout from the personal relationships you make as a business. Noteworthy links can be found at your local chamber of commerce just like any Hotfrog or elocal directory site. “This

Session Timeouts

We’re currently fixing a set of issues with a shopping cart created through a different developer for a local client. They did a pretty good job but forgot about session timeouts. A lot of developers gloss over this aspect of their ecommerce site and unfortunately customers pay the