Re: Backing up dbmail mysql innodb with mysqldump

Selon Paul J Stevens <paul@xxxxxx>:

> I use mysqldump --opt dbmail, but I guess it's a matter of taste.
> 
> 
> However, remember to execute:
> 
> SET FOREIGN_KEY_CHECKS=0;
> SET SQL_LOG_OFF=1;
> SET SQL_LOG_UPDATE=0;
> 
> before you start loading such a backup file. Esp if it's big.
> 
> So if dbmail.preload.mysql contains the previous statements,
> 
> mysql -e dbmail.preload.mysql dbmail < backup/dbmail.mysql
> 
> should be a clean recovery procedure.
> 
> 
> 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
> > 
> 
> -- 
>    ________________________________________________________________
>    Paul Stevens                                  mailto:paul@xxxxxx
>    NET FACILITIES GROUP                     PGP: finger paul@xxxxxx
>    The Netherlands________________________________http://www.nfg.nl
> _______________________________________________
> Dbmail mailing list
> Dbmail@xxxxxxxxxx
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> 

Thanks Paul for replying

Your basecly saying that my mysqldump command is
OK and i dont have to stop any services will i backup
and to use your exemple when i restore.

I my right
Thanks again