Re: Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8
Hello. Not enough information to make a conclusion. This could be a bug, say: http://bugs.mysql.com/bug.php?id=12410 Slawomir Orlowski (CYMPAK) wrote: 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 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8
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]
Re: Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8
Slawomir Orlowski (CYMPAK) wrote: 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 http://dev.mysql.com/doc/refman/4.1/en/mysqldump.html When you say --lock-all-tables does not work, what do you mean? Is there a specific error that you are running into? According to the documentation, this option will Lock all tables across all databases. However, there is a note that may be of interest to you, since you are using 4.1.8 --first-slave, -x Deprecated, renamed to --lock-all-tables in MySQL 4.1.8. Regards, Devananda vdv -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]