MySQLBackupScript: Difference between revisions

Latest revision as of 17:34, 4 March 2018

Moved to GitHub

/etc/crontab;

0 4 	* * * 	drew	/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
 ==Crontab Entry==
 /etc/crontab;
-<pre>0 4 	* * * 	drew	/home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</pre>
+<syntaxhighlight lang=bash>
+4 	* * * 	drew	/home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;
-OR
+</syntaxhighlight>
-crontab -e;
-<pre>0 4 * * *	/home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</pre>