Themergency fooplugins

WordPress Site URL Migration Generator

Generate a simple MySQL script to help you easily migrate your WordPress site from one URL to another.

This comes in handy when you are changing your site’s URL or migrating your site between development, test and live environments.

PLEASE NOTE : this should only be used in the most simple of site migrations. For more complex site moves, use a decent plugin like BackupBuddy!

  1. Fill in the fields
  2. Click ‘generate’
  3. copy the code and paste it into your MySQL management system (e.g. phpMyAdmin or HeidiSQL)
  4. execute the code and you are done!

e.g. http://www.google.com
11 comments
  Livefyre
  • Get Livefyre
  • FAQ
Newest | Oldest
shuvo khan
shuvo khan

Amazing. Thank you so much for this tool

Paypal VCC

Great tool none the less! Simple but yet effective!

magicroundabout
magicroundabout

Well, this isn't much good. It will probably break a whole load of things by not updating serialized data properly.  Look up something like the WordPress Move plugin that does this job properly.

bolstad
bolstad

Nice resource, but you can skip the first query -  the GUID should really not be changed, ever, since it's purpose is to be an unique and constant identifier. There is a section about it on the Codex: http://codex.wordpress.org/Changing_The_Site_URL#Important_GUID_Note

circlecube
circlecube

Very nice, thanks for the tool. What about another for auto generating the htaccess for redirects?

themergency
themergency moderator

 @magicroundabout This is not meant to be a plugin, but rather a simple tool to help people migrate their WP DB to another URL. It is by no means the all-in-one solution to migrate your sites. For that I would (and do) use BackupBuddy.

 

When you say "Look up something... that does the job properly", how do you know this script does not? When I move my local dev sites from one URL to another I have used this generator myself a dozen times successfully.

 

When you say "will probably break", did you test this? It has never broken my sites I have used it on in the past.

magicroundabout
magicroundabout

I've not tried it because I know it will only handle the most simple of sites. I'm sure there are cases where it does work, but I've done plenty of migrations myself and I know that there are many cases where the site's URL is stored in a serialised array: widget options for starters, but many themes and plugins do this too. Lets say you use an off-the-shelf image widget. Chances are that this will store an image URL in widget settings in wp_options. Your SQL will update the serialized string, but not update the character count and that widget's settings will break. I'm surprised that someone who seems to understand WordPress so well (your other generators are brilliant tools) thinks that this simple script is sufficient to do anything more than the most basic of moves. If there are limitations to what this can do - and I believe there are - then the generator should explain this. I'm sorry if my previous comment was too strongly worded. I was genuinely surprised at what I saw, especially as other Themergency stuff is so good.

themergency
themergency moderator

 @magicroundabout as I said in my previous comment :

 

"This is not meant to be a plugin, but rather a <b>simple tool</b> to help people migrate their WP DB to another URL. It is by <b>no means the all-in-one solution</b> to migrate your sites. For that I would (and do) use BackupBuddy."

 

But to make you happy, I have added a bold "PLEASE NOTE" section to generator