On 11/28/06, Warren Vail <warren@xxxxxxxxxxxx > wrote:
I think it becomes an issue only if the database structure is complex
with multiple related tables, and have lots of update activity. I think
most people design applications that don't require anything so complex,
and most queries are of the select variety.
Warren Vail
-----Original Message-----
From: Chris [mailto: dmagick@xxxxxxxxx]
Sent: Tuesday, November 28, 2006 2:50 PM
To: James Tu
Cc: PHP General List
Subject: Re: backing up a database
James Tu wrote:
> 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.
Because you don't need to. More of a mysql-mailing list question to be
honest.
C:\>mysqldump --help
--opt Same as --add-drop-table, --add-locks, --create-options,
--quick, --extended-insert, --lock-tables,
--set-charset,
and --disable-keys. *Enabled by default *, disable with
--skip-opt.
If you use the --opt flag, all is well...
David
