[Lias] MySQL backup

[Paul Gear]

Craig Ringer wrote:
>> How about a cron job in the middle of the night that does:
>>
>> mysqldump -p<password> --opt <database> | gzip -c - > <filename>.gz
> 
> 
> Using 'date -I' can be very handy with your backups.

Mmmm...  The one true date format!  :-)

> Even though you're
> writing to some removable media as well, it can be handy to have
> multiple on-line copies of the backups in case you need one.

We do all of our dumps (PostgreSQL, not MySQL, but the same principle
applies) to disk and then let the filesystem backup take care of
getting them to tape.  This means restores are much easier & faster.
-- 
Paul Gear
Manager IT Operations
Redlands College
38 Anson Road, Wellington Point 4160
07 3286 0271
(Please send attachments in portable formats such as PDF, HTML, or
OpenOffice.)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 252 bytes
Desc: not available
Url : http://lists.linux.org.au/pipermail/lias/attachments/20030717/e5156166/attachment.pgp