WordPress makes, in my opinion, the sin of storing serialized PHP data in the database. In my view using databases to store non-platform-agnostic information is always dangerous, but then I spent half my career working on cross-platform code and databases, so perhaps it’s just me.

Anyway, this always presented a problem for those of us migrating WordPress databases or even, just needing to do a quick search and replace across the entire database. For example, you might have moved office and wish to change all instances of your phone number on a website. It could be mentioned in a lot of posts, and in plugin settings.

And that’s why we wrote this little utility. In this incarnation if you drop it into your root folder it will pick up the WordPress DB connection settings, but if you wish to play safe and run the code elsewhere you’ll have to go into the code and set these yourself.

Ultimately you do have to be careful. This code can seriously damage the health of your database. It will cheerfully spend just a few seconds reducing your settings to rubble. So make sure you BACKUP FIRST!

To see how you can use this tool to aid migrations, check out the Interconnect IT article on WordPress migrations.

If you are in any doubt whatsoever about how to use this plugin, then please consider getting an expert in. You could even contact us over at Interconnect IT.

Download