Re: Backing up dbmail mysql innodb with mysqldump

jacques-beaudoin@xxxxxxxxxx wrote:

> Selon Chris Nolan <chris@xxxxxxxxxx>:
>
>  
>
> > jacques-beaudoin@xxxxxxxxxx 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
> > > Dbmail@xxxxxxxxxx
> > > 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
> > Dbmail@xxxxxxxxxx
> > 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
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
>