From f35d385229fc8b9520feabe232100c1b1bdf1176 Mon Sep 17 00:00:00 2001 From: Chris Koeritz Date: Mon, 16 Apr 2012 15:34:50 -0400 Subject: [PATCH] new script that backs up all the mysql databases. pretty general except password needs to be filled in. --- .../cron/backup_all_mysql_databases.crontab | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 database/configuration/cron/backup_all_mysql_databases.crontab diff --git a/database/configuration/cron/backup_all_mysql_databases.crontab b/database/configuration/cron/backup_all_mysql_databases.crontab new file mode 100644 index 00000000..3c465d4b --- /dev/null +++ b/database/configuration/cron/backup_all_mysql_databases.crontab @@ -0,0 +1,12 @@ + + +SHELL=/bin/bash + +# m h dom mon dow command + +USER=fred + +# backs up our databases on a weekly basis. +28 4 * * 2 (source $HOME/feisty_meow/scripts/core/launch_feisty_meow.sh; mysqldump -u root '-pPASSWORD' --all-databases | gzip > /z/stuffing/archives/database_backup_$(hostname)_$(date_stringer).sql.gz) &>/tmp/database_backup_${USER}.log + + -- 2.34.1