Hi, As I know, mysqldump --opt command will lock all the tables at once. I got confused from the above statement. What I have been confused is that if I have three databases. And I am trying to backup all three databases, using mysqldump --opt database1 > /xxx/datatbase1.sql ...etc... The above statement will lock all tables in the all databases or just the database1. Please help me out. Thank you Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php