Selon Chris Nolan <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > >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 > > > > > > I use the same mysqldump command you use. The READ_REPEATABLE statement > belongs in your MySQL configuration file. You need to insert the > following line: > > transaction-isolation = REPEATABLE-READ > > Hope this helps! > > > > >_______________________________________________ > >Dbmail mailing list > >[email protected] > >https://mailman.fastxs.nl/mailman/listinfo/dbmail > > > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
Hi Chris One last note. I found that transaction-isolation = REPEATABLE-READ is the mysql default. You can check the transaction-isolation of your system by typing SELECT @@tx_isolation; and SELECT @@global.tx_isolation; Thanks for your help Responsable des accès internet Internet security manager Pointe de l'Ile school board Montréal Québec Canada
