MySQLBackupScript - Revision history

Drew: Drew moved page MySQL Backup Script to MySQLBackupScript without leaving a redirect: rename to MySQLBackupScript

2018-03-05T00:34:07Z

Drew moved page MySQL Backup Script to MySQLBackupScript without leaving a redirect: rename to MySQLBackupScript

← Older revision		Revision as of 18:34, 4 March 2018
(No difference)

Drew at 08:20, 25 January 2018

2018-01-25T08:20:00Z

← Older revision		Revision as of 02:20, 25 January 2018
Line 5:		Line 5:
	==Crontab Entry==		==Crontab Entry==
	/etc/crontab;		/etc/crontab;
	<~~pre~~>0 4 * * * drew /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</~~pre~~>		<syntaxhighlight lang=bash>
			0 4 * * * drew /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;
			</syntaxhighlight>

Drew: /* Crontab Entry */

2018-01-24T20:29:28Z

Crontab Entry

← Older revision		Revision as of 14:29, 24 January 2018
Line 6:		Line 6:
	/etc/crontab;		/etc/crontab;
	<pre>0 4 * * * drew /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</pre>		<pre>0 4 * * * drew /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</pre>

	OR

	~~crontab -e;~~
	~~<pre>0 4 * * * /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</pre>~~

Drew at 00:47, 21 January 2018

2018-01-21T00:47:06Z

@@ Line 1: / Line 1: @@
 ==The Script==
-<pre>#!/bin/sh
+Moved to [https://github.com/invadelabs/cron-invadelabs/blob/master/mysql_backup.sh GitHub]
 *Need to get pw off console command

Drew at 18:07, 14 December 2008

2008-12-14T18:07:29Z

← Older revision		Revision as of 12:07, 14 December 2008
Line 11:		Line 11:
	mysqldump -u$USER -p$PW --all-databases \| gzip > $DIR/mysql.`hostname`.`date +%F.%T`.sql.gz;		mysqldump -u$USER -p$PW --all-databases \| gzip > $DIR/mysql.`hostname`.`date +%F.%T`.sql.gz;

	# ~~delete~~ backups older than 30 days		# DELETE backups older than 30 days
	find $DIR -type f -mtime +30 -exec rm -v {} \;</pre>		find $DIR -type f -mtime +30 -exec rm -v {} \;</pre>
			*Need to get pw off console command

	==Crontab Entry==		==Crontab Entry==

Drew: New page: ==The Script==

#!/bin/sh 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.`ho...

2008-12-14T18:05:52Z

New page: ==The Script== <pre>#!/bin/sh 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.`ho...

New page

==The Script==
<pre>#!/bin/sh
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>

==Crontab Entry==
/etc/crontab;
<pre>0 4 * * * drew /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</pre>

OR

crontab -e;
<pre>0 4 * * * /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;</pre>