Replace string in entire database

Bash on Linux.

Dump database to text file

mysqldump -u user -p databasename > ./db.sql

Run sed command to find/replace target string

sed -i 's/oldString/newString/g' ./db.sql

Reload the database into MySQL

mysql -u user -p databasename < ./db.sql

In OS X

In OS X, the sed -i command may throw out unterminated substitute pattern error.

Instead you can use:

sed -i '' -e 's/oldString/newString/g' ./db.sql