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]