By emsbrooklyn on

Pretty new to databases, but I need to do a search and replace through the entire MySQL database. Is there a way to use phpMyAdmin to do a Find and Replace for the entire database?

Thanks!

⋅ Categories: Drupal 5.x

Comments

missym’s picture

missym commented

1. Make a backup. Maybe make 2.
2. Lookup mysql update syntax online
3. Using phpMyAdmin, choose SQL and put your update command into the SQL box and submit it.
4. Check your data.

This is very powerful. If you are scared and it's only one or two tables without relations, export the whole thing to excel and do your changes there. Save it as CSV. Go to phpMyAdmin, empty the table and import the CSV file(s) you created.