Title: mPress Fix URL References
Author: Micah Wood
Published: <strong>December 8, 2012</strong>
Last modified: June 4, 2016

---

Search plugins

This plugin **hasn’t been tested with the latest 3 major releases of WordPress**.
It may no longer be maintained or supported and may have compatibility issues when
used with more recent versions of WordPress.

![](https://s.w.org/plugins/geopattern-icon/mpress-fix-url-references.svg)

# mPress Fix URL References

 By [Micah Wood](https://profiles.wordpress.org/woodent/)

[Download](https://downloads.wordpress.org/plugin/mpress-fix-url-references.1.0.zip)

 * [Details](https://test.wordpress.org/plugins/mpress-fix-url-references/#description)
 * [Reviews](https://test.wordpress.org/plugins/mpress-fix-url-references/#reviews)
 *  [Installation](https://test.wordpress.org/plugins/mpress-fix-url-references/#installation)
 * [Development](https://test.wordpress.org/plugins/mpress-fix-url-references/#developers)

 [Support](https://wordpress.org/support/plugin/mpress-fix-url-references/)

## Description

The **mPress Fix URL References** plugin allows you to easily fix URL references
in your WordPress database.

#### Why?

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.

#### How?

Using this plugin is simple:

 1. Ensure that you define the [WP_HOME](https://codex.wordpress.org/Editing_wp-config.php#Blog_address_.28URL.29)
    and [WP_SITEURL](https://codex.wordpress.org/Editing_wp-config.php#WordPress_address_.28URL.29)
    constants in your wp-config.php file. It’s not that hard.
 2. Install the plugin
 3. Activate the plugin
 4. In the WordPress admin, click on ‘Fix URL References’ in the ‘Tools’ menu
 5. Enter the URL that you want to have replaced
 6. Click on ‘Fix References’

#### Features

 * Clean, well written code that won’t bog down your site

## Screenshots

 * [[
 * Go to ‘Tools’ -> ‘Fix URL References’ to get started.

## Installation

#### Prerequisites

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.

 * Requires WordPress version 3.2 or greater
 * Requires PHP version 5 or greater ( PHP version 5.2.4 is required to run WordPress
   version 3.2 )

#### The Easy Way

 1. In your WordPress admin, go to ‘Plugins’ and then click on ‘Add New’.
 2. In the search box, type in ‘mPress Fix URL References’ and hit enter. This plugin
    should be the first and likely the only result.
 3. Click on the ‘Install’ link.
 4. Once installed, click the ‘Activate this plugin’ link.

#### The Hard Way

 1. Download the .zip file containing the plugin.
 2. Upload the file into your `/wp-content/plugins/` directory and unzip
 3. Find the plugin in the WordPress admin on the ‘Plugins’ page and click ‘Activate’

#### Usage Instructions

Before you do anything else, this plugin requires that you define the [WP_HOME](https://codex.wordpress.org/Editing_wp-config.php#Blog_address_.28URL.29)
and [WP_SITEURL](https://codex.wordpress.org/Editing_wp-config.php#WordPress_address_.28URL.29)
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.

## FAQ

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.

## Reviews

![](https://secure.gravatar.com/avatar/1563d14e94cbf9fe49ddec070aae9a2d8aebb5fc5bc3a5f3a4b30a1af80fc137?
s=60&d=retro&r=g)

### 󠀁[Removed all tables](https://wordpress.org/support/topic/removed-all-tables/)󠁿

 [dclijste](https://profiles.wordpress.org/dclijste/) September 3, 2016

Does not work with 4.5.3, I tried several times, each time restoring the DB back
after losing all CSS and other changes

![](https://secure.gravatar.com/avatar/b07132b8523056f1220817052b0e88bc1de13ed39e8ada6b7e782aadbbfbce64?
s=60&d=retro&r=g)

### 󠀁[Lost a lot of data to this plugin](https://wordpress.org/support/topic/lost-a-lot-of-data-to-this-plugin/)󠁿

 [RickyT23](https://profiles.wordpress.org/rickyt23/) September 3, 2016

Entered my URLs without a slash at the end. Deleted many tables entirely. Lost my
custom CSS styles & my theme settings. Backup first!!

 [ Read all 5 reviews ](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/)

## Contributors & Developers

“mPress Fix URL References” is open source software. The following people have contributed
to this plugin.

Contributors

 *   [ Micah Wood ](https://profiles.wordpress.org/woodent/)

[Translate “mPress Fix URL References” into your language.](https://translate.wordpress.org/projects/wp-plugins/mpress-fix-url-references)

### Interested in development?

[Browse the code](https://plugins.trac.wordpress.org/browser/mpress-fix-url-references/),
check out the [SVN repository](https://plugins.svn.wordpress.org/mpress-fix-url-references/),
or subscribe to the [development log](https://plugins.trac.wordpress.org/log/mpress-fix-url-references/)
by [RSS](https://plugins.trac.wordpress.org/log/mpress-fix-url-references/?limit=100&mode=stop_on_copy&format=rss).

## Changelog

#### 1.0

 * Updated to release version after testing in WordPress 4.5.2

#### 0.2

 * Removed deprecated screen_icon() function (props Shelob9)

#### 0.1

 * Initial commit

## Meta

 *  Version **1.0**
 *  Last updated **10 years ago**
 *  Active installations **90+**
 *  WordPress version ** 3.2 or higher **
 *  Tested up to **4.5.33**
 *  Language
 * [English (US)](https://wordpress.org/plugins/mpress-fix-url-references/)
 * Tags
 * [database](https://test.wordpress.org/plugins/tags/database/)[migrate](https://test.wordpress.org/plugins/tags/migrate/)
   [migration](https://test.wordpress.org/plugins/tags/migration/)[mpress](https://test.wordpress.org/plugins/tags/mpress/)
   [url](https://test.wordpress.org/plugins/tags/url/)
 *  [Advanced View](https://test.wordpress.org/plugins/mpress-fix-url-references/advanced/)

## Ratings

 3.4 out of 5 stars.

 *  [  3 5-star reviews     ](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/?filter=5)
 *  [  0 4-star reviews     ](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/?filter=4)
 *  [  0 3-star reviews     ](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/?filter=3)
 *  [  0 2-star reviews     ](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/?filter=2)
 *  [  2 1-star reviews     ](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/#new-post)

[See all reviews](https://wordpress.org/support/plugin/mpress-fix-url-references/reviews/)

## Contributors

 *   [ Micah Wood ](https://profiles.wordpress.org/woodent/)

## Support

Got something to say? Need help?

 [View support forum](https://wordpress.org/support/plugin/mpress-fix-url-references/)

## Donate

Would you like to support the advancement of this plugin?

 [ Donate to this plugin ](https://www.paypal.me/wpscholar)