RE: [PHP] backing up a database
| From: | Kristen G. Thorson | Date: | Wed, 29 Nov 2006 14:57:21 +0000 |
| Subject: | RE: [PHP] backing up a database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-245278@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: James Tu [mailto:jtu@esidesign.com]
> Sent: Tuesday, November 28, 2006 5:03 PM
> To: PHP General List
> Subject: Re: [PHP] 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