[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
