The mPress Fix URL References plugin allows you to easily fix URL references in your WordPress database.
When you move your site from one domain to another, there is no built-in process for updating URL references in the database. For example, if you have internal links in your post content that point to the full URL of other pages on your site, these URL references will become invalid when you migrate your site to a new domain. If you aren’t a developer who knows how to write MySQL queries, replacing potentially thousands of instances of incorrect URLs is a real pain. No worries. I’m a developer and I’ve done all the work for you.
Ensure that you define the WP_HOME and WP_SITEURL constants in your wp-config.php file. It’s not that hard.
Go to 'Tools' -> 'Fix URL References' to get started.
In the search box, type in ‘mPress Fix URL References’ and hit enter. This plugin should be the first and likely the only result.
Before you do anything else, this plugin requires that you define the WP_HOME and WP_SITEURL constants in your wp-config.php file.
Once the plugin is installed and activated, just click on ‘Fix URL References’ in the ‘Tools’ menu on the left hand side in the WordPress admin area. Next, simply enter the old URL you want to have replaced and click ‘Fix References’. Yep… it’s that easy.
By default, this plugin only replaces URLs in specific tables and fields that would typically have URL references. I understand that this doesn’t meet everyone’s use cases, so this plugin exposes a simple PHP function for replacing string content from any given table and field.
Notice how the table name doesn’t include the WordPress table prefix. This gets added automatically.
Entered my URLs without a slash at the end. Deleted many tables entirely. Lost my custom CSS styles & my theme settings. Backup first!!
“mPress Fix URL References” is open source software. The following people have contributed to this plugin.
Translate “mPress Fix URL References” into your language.