Another splendid idea from Mark Jackson (MJ Digital). This loops through the database and replaces a certain string with another… Ideal is a site name has been changed…. Or I use it when a Drupal site goes live and needs to be switched from the test site (on a subdomain) to the live domain…

Recently improved by Eric Amundson, who has taken the script and added an easy to use front end. Between them they have released it under the GPL in the hope it may help more people.

http://sewmyheadon.com/2009/mysql-search-replace-tool/

Personally, I still prefer Marks version as my databases are on a live server, so I just fill in the DB details, upload the file, run it from a browser, delete the uploaded file….

Simple!

Nice work Mark!