Selon Paul J Stevens <[EMAIL PROTECTED]>: > 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. > > > [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 > > > > -- > ________________________________________________________________ > Paul Stevens mailto:[EMAIL PROTECTED] > NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED] > The Netherlands________________________________http://www.nfg.nl > _______________________________________________ > Dbmail mailing list > [email protected] > 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
