hello, I have mysql-4.1.8 compiled form source working on RH7.2. I have tried to backup my database with mysqldump.
> mysqldump --opt database_name > database_name.sql > mysqldump --lock-tables database_name > database_name.sql > mysqldump --skip-opt --lock-tables database_name > database_name.sql > mysqldump --lock-all-tables database_name > database_name.sql Unfortunately options --lock-tables, --lock-all-tables do not work. Only --add-locks works (alone or as part of --opt) but it can cause some inconsistencies because it locks tables individually. How to lock all tables at once? I would appreciate any help. Best regards Slawomir Orlowski -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]