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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
