Easily fix URL references in your WordPress database.
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.
Using this plugin is simple:
If you don’t meet the below requirements, I highly recommend you upgrade your WordPress install or move to a web host
that supports a more recent version of PHP.
/wp-content/plugins/
directory and unzipBefore 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.
Please only use this function if you know what you are doing:
mPress_Fix_URL_References::run_replacement_query( $table, $field, $old, $new );
This plugin replaces content in the ‘post_content’ field in the ‘posts’ table. The line of code below is from this plugin and is given as an example of how to use this function:
mPress_Fix_URL_References::run_replacement_query( 'posts', 'post_content', 'http://www.old-domain.com', 'http://www.new-domain.com' );
Notice how the table name doesn’t include the WordPress table prefix. This gets added automatically.