Jim Oltman wrote:
How big does this DB-dump get?
On Mon, 14 Mar 2005 08:17:29 -0800, Ian Forde <[EMAIL PROTECTED]> wrote:
On Mon, 2005-03-14 at 07:25 +0000, David Morrison wrote:
Obviously, I'm not doing any backups otherwise I wouldn't be grumblingWhich is why I put this little gem into a script in /etc/cron.daily:
so much :-)
or rolling backups
12 4 * * 0 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /bin/gzip > /myth/backup/mythtv_backup.sql.sun.gz
12 4 * * 1 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /bin/gzip > /myth/backup/mythtv_backup.sql.mon.gz
12 4 * * 2 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /bin/gzip > /myth/backup/mythtv_backup.sql.tue.gz
12 4 * * 3 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /bin/gzip > /myth/backup/mythtv_backup.sql.wed.gz
12 4 * * 4 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /bin/gzip > /myth/backup/mythtv_backup.sql.thu.gz
12 4 * * 5 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /bin/gzip > /myth/backup/mythtv_backup.sql.fri.gz
12 4 * * 6 /usr/bin/mysqldump -u mythtv -pmythtv mythconverg -c | /bin/gzip > /myth/backup/mythtv_backup.sql.sat.gz
mine are a bit bigger than 9Mb each:
-rw-r--r-- 1 root root 54405962 Mar 11 04:13 mythtv_backup.sql.fri.gz
-rw-r--r-- 1 root root 42468923 Mar 14 04:13 mythtv_backup.sql.mon.gz
-rw-r--r-- 1 root root 54779342 Mar 12 04:13 mythtv_backup.sql.sat.gz
-rw-r--r-- 1 root root 55247614 Mar 13 04:13 mythtv_backup.sql.sun.gz
-rw-r--r-- 1 root root 54053697 Mar 10 04:13 mythtv_backup.sql.thu.gz
-rw-r--r-- 1 root root 57641490 Mar 8 04:13 mythtv_backup.sql.tue.gz
-rw-r--r-- 1 root root 53933510 Mar 9 04:13 mythtv_backup.sql.wed.gz
David
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
