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.