On Tuesday 22 August 2006 11:26, Tzahi Fadida wrote: > On Monday 21 August 2006 11:54, you wrote: > > Hi all, > > I would like to get some advice for a backup utility with the following > > capabilities: > > > > 1. Be able to snap-shot directories and databases (not the entire file > > system). > > You need to specify what databases. Most databases need to be closed > before copied or you will have discrepancies in the data. > Not only that, if you will try to use the database files in the future > with even a slightly different version of the software it might not work. > You'd better run a script to dump all the database into a text file. > all databases can do that. > MySQL in general, but I don't see the need to shut down the database. A nice feature I liked in rsnapshot suggested here, is the ability to use custom scripts. On the subject, there is a mysqldump script to backup mysql databases.
I find this option very desireable, since mysqldump can lock a database and dump it. It is far better than snapshotting raw files. Other databases usually have similar tools to dump a database to SQL statements, along with locking mechanism (if supported by the database). > > 2. Perform incremental backups (at least for directories) > > 3. Good integrity checks > > 4. Sane recovery process > > > > The main problem I have with rsync and friends is that I cannot get just > > the increment between two snapshots. > > > > Any recommendation will be much appreciated. > > > > Thanks, > > Ami > > > > ================================================================= > > To unsubscribe, send mail to [EMAIL PROTECTED] with > > the word "unsubscribe" in the message body, e.g., run the command > > echo unsubscribe | mail [EMAIL PROTECTED] ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
