I have been using --single-transaction for my backups...this only works with transaction capable storage though, such as InnoDB.
Just my 2 cents. Angus On Thu, 24 Mar 2005 08:12:43 -0800, Christian G. Warden <[EMAIL PROTECTED]> wrote: > On Thu, Mar 24, 2005 at 11:10:30AM -0000, Simon Gray wrote: > > >mysqldump works-for-me. > > > > Doesn't mysqldump lock the table though? So any new inbound (insert) email > > will have to wait until the lock is free - not really a problem as long as > > the mta queues it. > > You could use --single-transaction to get a consistent backup without > locking the tables. > > xn > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
