On Mon, 14 Mar 2005 08:17:29 -0800, Ian Forde
<[EMAIL PROTECTED]> wrote:
> Which is why I put this little gem into a script in
/etc/cron.daily:
>
> #!/bin/sh
> datenow=`date +"%Y%m%d"`
> mysqldump --opt mythconverg >
/var/lib/backups/mysqldump-${datenow}.sql
> gzip -9 /var/lib/backups/mysqldump-${datenow}.sql
A couple suggestions:
1) Only back up specific tables by specifying them
after
'mythconverg' in your mysqldump line.
e.g. mysqldump --opt mythconverg settings caturecard
cardinput
2) using a pipe vs. redirect will save interim
drive space.
e.g. mysqldump --opt mythconverg settings capturecard
| gzip -9 -c > backup.sql.gz
3) bzip2 does a better job at compressing my DB
than gzip
-Dennis
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
