Hello, I used to use the FreeBSD UFS2 snapshots, but have since abandoned them since I had too many problems with them, it may be better now in 5.4; I was using 5.1 at the time. I have all my tables (in MySQL) in InnoDB format, and do a mysqldump using the --single-transaction switch. This should get a consistent backup as it does all of the SQL commands inside of a single transaction. I have done many restores to test this out, and haven't had any issues so far.
I personally prefer to do the database dump *before* doing the dbmail-util -ay. This way I have a consistent backup before doing any deletes or updates on the database. Perhaps other will disagree with this strategy, but it has worked for me for over a year now. Fingers crossed! If you are using a PostgreSQL database, then you need not worry about interrupting the database while doing a backup. I am by no means an expert on PostgreSQL, but from my understanding you can do a pg_dump -Ft (or other similar command) and this will get a perfectly consistent DB backup without interrupting any users currently in the database. Someone correct me if I'm wrong here. Hope that helps a little, Angus Jordan. On 7/6/05, Andy Hilker <[EMAIL PROTECTED]> wrote: > > Hi, > > You (Niblett, David A) wrote: > > Just curious out there how others do their database maintenance > > and backups. > > on FreeBSD with UFS2 you can use filesystem snapshots to make > consistent backups without locking the database and interrupting > service. > > bye, > Andy > > -- > Andy Hilker -- mailto:[EMAIL PROTECTED] > http://www.cryptobank.de -- PGP Key: https://ca.crypta.net > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
