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. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php