On 25 Mar 2004, at 15:23, joe collins wrote:
Hi,
anyone know what happens if, while I am doing a database dump, someone logs
into the database and updates records, what records are trapped in the dump,
or can the dump proceed under this circumstance...in other words must I
knock all users off the database before the dump is done?
mysqldump, if used with the --lock-tables option (which is implied by --opt) obtains read locks, so queries attempting to update the database will block until the dump has finished.
Tim
-- Dr Tim Cutts Informatics Systems Group Wellcome Trust Sanger Institute Hinxton, Cambridge, CB10 1SA, UK
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
