Selon Chris Nolan <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > >I use the command > > > >mysqldump --quick --single-transaction -uroot > /backup/dbmail.sql > > > >to backup my dbmail database. > > > >It works fine but im wondering if any sql gouru have any opinions > >about this. > > > >I dont stop any of my services (postfix,dbmail,amavis) will i backup. > > > >Thanks > >Jacques > >_______________________________________________ > >Dbmail mailing list > >[email protected] > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > It depends on whether you use InnoDB tables or not and your isolation level. > > If you don't use InnoDB tables, there is a strong possibility of an > inconsistent database state occuring. > > If you do use InnoDB tables, you will need to set your isolation level > to READ_REPEATABLE to get a consistent snapshot. > > Regards, > > Chris > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail > Thanks Chris for your reply
When i created my dbmail-mysql-database i wrote to all my create table statement type=innodb if that what you mean by using innodb statement. Where is that READ_REPEATABLE statement goes. Can you give the complet mysqldump command you use. Thanks again Jacques
