Search and Replace for WordPress Databases
So if you ever want to change the name of a WordPress or Drupal site you might be in for some fun. Somewhere along the line it became acceptable to embed serialized data into the database. This seems like a great idea (?) until you do a search and replace on exported database files, and notice that many things stop working.
Using serialized data like this in the Database goes against the grain. I’m sure Dr. Codd is rolling in his grave.
Luckily I have found a very useful script that I have used many times now and it works very well for wordpress, and in theory Drupal too. It is from David Coveney and can be found here. Thanks Dave!