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]