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
