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

Post a Comment

Popular posts from this blog

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 -

In brief, the wrapper module is inserted during posting and the status of an entry is changed to 'modified' . Before changing the state, the state is set to 'separate', but calling attachments () causes the same error to be thrown away. I am using EF 6. Model / wrapper class public class avi model {public A is a {get; Set; } Public listing & lt; B & gt; B {received; Set; } Public cc {receipt; Set; }} Administrator edit public functioning (int? id) {if (id == null) {new HttpStatusCodeResult (HttpStatusCode.BadRequest); } If (! Conveyor Access (id.Value)) new HTTPTitus code result (HTTP status code. Forbidden); Var aViewModel = new AViewModel (); aViewModel.A = db.As.Find (id); If (aViewModel.Receipt == zero) {return HttpNotFound (); } aViewModel.b = db.Bs.Where (x => x.aid == id.Value) .Oolist (); AViewModel.Vendor = db.Cs.Where (x => x.cid == aViewModel.a.cID) .FirstOrDefault (); See Return (aViewModel); } [HTPFost] [Valid AntitiferousTeacon...
Read more

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

I use iReport 5.5.0 . How to align a barcode component to the center The relevant piece of my jrxml is below & Lt; JR: Code 128 xmlns: JR = "http://jasperreports.sourceforge.net/jasperreports/components" xsi: schemaLocation = "http://jasperreports.sourceforge.net/jasperreports/components http: //jasperreports.sourceforge Purge / xsd / components.xsd "textPosition =" bottom "& gt; & Lt; Jr: codeExpression & gt; & Lt; [CDATA [$ F {number}]] & gt; & Lt; / Jr: codeExpression & gt; & Lt; / Jr: Code 128 & gt; & Lt; / componentElement & gt; "Text" itemprop = "text"> Create a style after this, it is called "barcode", like: & lt; Style name = "barcode" fontName = "Helvetica" fONTSIZE = "10" hAlign = "center" valign = "center" /> and set the property of your barcode element to "barcode".
Read more

django - CommandError: You must set settings.ALLOWED_HOSTS if DEBUG is False -

I use Django 1.6.5 with settings in my program txsite: DEBUG = true I set the lie to debug, but when I get the runner , I get the following error: CommandError: You have to set the settings. OLOWOWHESTS If DEBUG is False I ALLOWED_HOSTS = ['127.0.0.1', 'localhost'] but I get the same error. Does anyone know this address? Try ALLOWED_HOSTS = ['*'] Less secure If you are not on a firewall or public LAN, but what I use and it works. Edit: Interestingly enough, I have to add some of my 1.8 projects, even if DEBUG = True . Why so very uncertain
Read more