[EMAIL PROTECTED] wrote:
Selon Chris Nolan <[EMAIL PROTECTED]>:
[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
_______________________________________________
Dbmail mailing list
[email protected]
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
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
