PHP/MySQL Full Database Search and Replace

September 1st, 2009

I wrote this because I often need to move data-driven sites from development to production and addresses change.  (Wordpress sites, Wordpress MU, Drupal,  and so on.)  This means I have to go through and change every occurrence of the url as it appears in the database.  So when the first few solutions for changing the site url aren’t doing the trick, I have to resort to the following MySQL snippet for updating every single table.

To find a string in a certain field and replace it with another string:

update [table_name]
  set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

Well, I got tired of doing that and wrote a handy snippet to find and replace across an entire database.

There are no checks or safeguards!  This is a quick and dirty script to be used at your own risk!

But if it’s useful, please feel free to say so in the comments.

UPDATE

Added two checkboxes:

1. Set the script to never timeout (use with caution!)
2. Do a case-insensitive find and replace. (use with caution!)

Download the updated .rar here

Tags: download, find and replace, full db, mysql, php, replace, search, search and replace, update
Posted in geek, technology | 11 Comments »