MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Slawomir Orlowski \(CYMPAK\) Date:October 21 2005 8:06pm
Subject:Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8
View as plain text  
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


Thread
Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8Slawomir Orlowski \(CYMPAK\)21 Oct
  • Re: Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8Devananda22 Oct
  • Re: Options --lock-tables, --lock-all-tables do not work in mysql-4.1.8Gleb Paharenko22 Oct