2008/12/10 Sridhar Dhanapalan <[EMAIL PROTECTED]>:
> 2008/11/28 Mary Gardiner <[EMAIL PROTECTED]>:
>> If you're backing up databases (eg, MySQL for your blog or whatever)
>> make sure to dump them before backing up: live database backups seldom
>> restore well, you need dumps.
>
> Are there any good tools to backup/restore databases, with versioning,
> delta storage and so on just like you get with rdiff-backup? I'm
> currently running mysqldump and pg_dump in a shell script via cron
> job, but surely there's a better way. I've seen a few tools, but what
> do people on the list recommend?
I've heard about database data and schema versioning tools over the
years but unfortunately can't remember anything off the top of my head
right now. It's worth googling - there is stuff to be found (e.g.
"{mysql,postgresql} incremental backup" comes up with interesting
links).
(Looking through my google bookmarks I found the following which might
help versioning database schemas:
http://search.cpan.org/~crakrjack/DBIx-Migration-Directories/)
One thing I remember (but haven't yet got around to implement myself)
is to backup the database logs - that way you get full "point-in-time"
restoration capability as well as relatively more efficient backup
(both in time and in space), and it's contineous so can be used to
recover up to the point that disaster struck.
Here is a specific link from the MySQL docs:
http://dev.mysql.com/doc/refman/5.0/en/backup.html
and from the PostgresQL docs:
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
Cheers,
--Amos
--
SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
