> -----Original Message----- > From: James Tu [mailto:jtu@xxxxxxxxxxxxx] > Sent: Tuesday, November 28, 2006 5:03 PM > To: PHP General List > Subject: Re: backing up a database > > Thanks Brad: > > I'm just surprised that when people mention mysqldump, most of the > time they don't talk about locking the tables at all. > I'm curious why this is the case. > > -James > Unless you tell mysqldump not to lock tables, or change the defaults, it automatically locks: "For example, use of --opt is the same as specifying --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. Note that as of MySQL 4.1, all of the options that --opt stands for also are on by default because --opt is on by default." http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
