mysql - mysqldump always returns "option '--tables' cannot take an argument" -


Trying to back up a MySQL database using the mysqldump command, but the message I get is mysqldump: option '-

- Babes' can not take any argument .

Here you are:

  root @ myhost: ~ # mysqldump mydatabase - User Menu - Password mypassword Warning: Exceptions to tables instead of using the prefix table, and disliking it Will be removed in future releases. Please use the full name instead. Mysqldump: option '- tables' can not take a logic   

I have tried many logic combinations, but in the end I came to know that the result is the same if I just want to get the command version I try or do not have any logic:

  root @ myhost: ~ # mysqldump --version Warning: Unlike tables, using the prefix table, the unique option is disliked and removed in a future release. Will go Please use the full name instead. Mysqldump: The option '- tables' can not take any argument root @ myhost: ~ # mysqldump Warning: Using the prefix table of unique options instead of tables is disliked and will be removed in future releases. Please use the full name instead. Mysqldump: option '- tables' can not take any argument   

As you can see in the following rows, it is running mysql server 5.5 on debian 7 .

System version:

  root @ myhost: ~ # uname -a Linux MyHost 3.2.0-4-AMD64 # 1 SMP Debian 3.2.41-2 + deb 7z2 x86_64 GNU / Linux   

mysql client version:

  root @ myhost: ~ # mysql --version mysql Ver 14.14 distrib 5.5.35, Debian   

mysql server version:

  root @ myhost: ~ # mysql -h localhost - using Linux-GNU (x86_64) Readline 6.2: User = myuser --password = mypassword mydatabase Reading table information for completion of table and column names You are welcome to MySQL Monitor Together can turn this feature off to a quick start. Finished with order; Or your MySQL connection ID 75 server version: 5.5.35-0 + Vives 1-Log (Debian) Copyright (C) 2000, 2013, Oracle and / or its affiliates All Rights Reserved. Oracle is a registered trademark of Oracle Corporation and / or its affiliates names may be trademarks of their respective owners. Type 'help;' Or '\ c' to clear the current input statement, type '\ c' mysql & gt; I left this problem on the web, but I can not see anyone reporting this exact issue. I'm not an expert on mysql, but I can say that this is a very simple installation. You need more information, please tell me.  

In advance, Ivan

After the decoder signals I / Etc / mysql / my.cnf , among others,

  [client] port = 3306 socket = / var / run / sq / mysql / Mysqld / mysqld.sock table = true   

Mysqldump command works after removing the table = true line from my.cnf According to:

  root @ myhost: ~ # mysqldump Usage: mysqldump [options] database [tables] or mysqldump [options] - database [options] db1 [db2 db3 ..] Y Mysqldump [Options] - All databases [Options] For more options, use mysqldump --help   

My conclusion is that the table = true option Mysqldump is not suitable for commands and should be removed from the [client] option file. [Client] section group option settings are applied to all client programs.

Whether other commands require that option set, it should be placed in another program section, neither [mysqldump] nor [customer] < / Code>.

Comments

Popular posts from this blog

Verilog Error: output or inout port "Q" must be connected to a structural net expression -

jasper reports - How to center align barcode using jasperreports and barcode4j -

c# - ASP.NET MVC - Attaching an entity of type 'MODELNAME' failed because another entity of the same type already has the same primary key value -