Re: backing up a database

On 11/28/06, Warren Vail <warren@vailtech.net > 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@gmail.com] Sent: Tuesday, November 28, 2006 2:50 PM To: James Tu Cc: PHP General List Subject: Re: [PHP] 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