Top tip o’ the day.
Every now and then I need to search through an entire mySQL database, to change a word, term, URL, or some other string. rather than searching through the entire database to make the change, I just use phpMyAdmin to export the whole thing as an .sql file, which is of course just plain text.
Open it in a text editor, find and replace in there, then reupload to phpMyAdmin.
In short, I get it done easily in a bout 45 seconds without having to worry about a tupo in an SQL query destroying my data.
