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