2 messages in com.mysql.lists.mysqlRe: MYSQLD Dump - Locks Database
FromSent OnAttachments
Paul Fine13 Nov 2003 05:13 
Peter Sap16 Nov 2003 10:43 
Subject:Re: MYSQLD Dump - Locks Database
From:Peter Sap (ps@xs4all.nl)
Date:11/16/2003 10:43:08 AM
List:com.mysql.lists.mysql

As far as I know no locking will be done, unless you use the --lock-tables flag: the tables in a database are locked before the dump starts. When using InnoDb, use the flag --single-transaction to get a consistent snapshot of your database.

Peter Sap

----- Original Message ----- From: "Paul Fine" <pfi@of-law.com> To: <mys@lists.mysql.com> Sent: Thursday, November 13, 2003 2:13 PM Subject: MYSQLD Dump - Locks Database

Can anyone please tell me what if anything happens with database locking during the execution of a mysqldump? Ie. What happens to database transactions occurring while performing a dump?

Thanks!