MySQLBackupScript: Difference between revisions
Jump to navigation
Jump to search
m (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...) |
m (Drew moved page MySQL Backup Script to MySQLBackupScript without leaving a redirect: rename to MySQLBackupScript) |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==The Script== | ==The Script== | ||
Moved to [https://github.com/invadelabs/cron-invadelabs/blob/master/mysql_backup.sh GitHub] | |||
*Need to get pw off console command | |||
==Crontab Entry== | ==Crontab Entry== | ||
/etc/crontab; | /etc/crontab; | ||
< | <syntaxhighlight lang=bash> | ||
0 4 * * * drew /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log; | |||
</syntaxhighlight> | |||
Latest revision as of 17:34, 4 March 2018
The Script
Moved to GitHub
- Need to get pw off console command
Crontab Entry
/etc/crontab;
0 4 * * * drew /home/drew/cron/mysql_backup.sh >> /home/drew/cron/mysql_backup.log;