MySQLBackupScript: Difference between revisions

Revision as of 17:47, 20 January 2018

Moved to GitHub

/etc/crontab;

0 4 	* * * 	drew	/home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;

OR

crontab -e;

0 4 * * *	/home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;

@@ Line 1: / Line 1: @@
 ==The Script==
-<pre>#!/bin/sh
+Moved to [https://github.com/invadelabs/cron-invadelabs/blob/master/mysql_backup.sh GitHub]
-USER=some_user
-PW=some_pw
-DIR=/mnt/raid5/backup/mysql
-echo Running: `date`;
-mkdir -vp $DIR;
-mysqldump -u$USER -p$PW --all-databases | gzip > $DIR/mysql.`hostname`.`date +%F.%T`.sql.gz;
-# DELETE backups older than 30 days
-find $DIR -type f -mtime +30 -exec rm -v {} \;</pre>
 *Need to get pw off console command