The connections will still write to one or two tables. Mainly stock prices from a price server. Hence, not so bother if any prices arrive after the dump starts are not captured. I would like to know if mysqldump will fail to run if the tables are not locked? Cheers. Gilbert
-----Original Message----- From: Sent: 15 July 2003 17:11 To: Gilbert Wu Subject: Re: MySQLDump sure, just tell it to lock the tables while it does the dump. curtis On Tuesday 15 July 2003 12:02, Gilbert Wu wrote: > Hi, > > I am new to MySQL. I wonder if someone could tell me if I can run MySQLDump > on a database while a few users are still connected to it. If yes, is it > clever enough to backup the transaction log and use it to restore the > database to the nearest state to the before the dump? > > Many thanks. > > Gilbert Wu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
