Shell Script To Dump All MySQL Databases Every Hour To NAS Storage

by Tweak on June 12, 2009
in Mysql, Servers

+ Download this script
+ Modify settings according to your setup
+ Install cron job as follows to run script every hour

# Backup database every 1 hr to folder /nas/mysql
@hourly /root/scripts/db1hr.backup.sh >/dev/null 2>&1

Sample Shell Script To Dump All MySQL Databases
Read more…