Posts Tagged ‘ dump ’

Database wide search and replace script

Aug 21st, 2012 | By

Just something I thought that I would post as I needed a quick solution to do a search and replace of an entire Mysql Database.  It’s actually dumping the DB, searching and replacing the dump file and then re-importing it.  But it does the trick   #!/bin/bash if (($# >= 1)) ; then if (($#
[continue reading…]

Backup all mysql databases to individual files

Feb 16th, 2011 | By

Thanks go out to Sonia Hamilton, as her blog is where I found the original version of this script, however it did need a fair bit of tweaking to work properly in BSD so I went ahead and redid parts of it  as you can see below. This script will back up each of your
[continue reading…]