mysqldump抱怨select的数据库,不pipe命令行

mysqldump抱怨我从来没有指定的命令行选项。 我没有shell别名也没有自定义.my.cnf文件集。 我究竟做错了什么?

使用--database long选项:

 $ mysqldump --user cloud -p --database cloud > backup.mysqldb Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. Warning: mysqldump: ignoring option '--databases' due to invalid value 'cloud' Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. 

使用--databases long选项:

 $ mysqldump --user cloud -p --databases cloud > backup.mysqldb Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. Warning: mysqldump: ignoring option '--databases' due to invalid value 'cloud' 

使用--all-databases long选项:

 $ mysqldump --user cloud -p --all-databases > backup.mysqldb Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. Warning: mysqldump: ignoring option '--databases' due to invalid value 'cloud' 

只使用数据库名称:

 $ mysqldump --user cloud -p cloud > backup.mysqldb Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. Warning: mysqldump: ignoring option '--databases' due to invalid value 'cloud' 

最后, 没有任何说明

 $ mysqldump --user cloud -p > backup.mysqldb Warning: Using unique option prefix database instead of databases is deprecated and will be removed in a future release. Please use the full name instead. Warning: mysqldump: ignoring option '--databases' due to invalid value 'cloud' 

.my.cnf选项文件中,您可能已经为所有客户端指定了数据库参数,但mysqldump不喜欢该参数。 所以不要在选项文件中列出所有客户端的参数。

例如,下面是我如何解决它,所以MySQL客户端仍然工作,没有指定数据库(默认名称“走”)和mysqldump不抱怨:

之前:

  $ cat〜/ .my.cnf
 [客户]
用户=根
主机= 127.0.0.1
密码=“根”
 数据库=走着

后:

  $ cat〜/ .my.cnf
 [客户]
用户=根
主机= 127.0.0.1
密码=“根”

  [MySQL的] 
  数据库=走着