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的] 数据库=走着