MySQL数据备份"--no-beep"异常解决
来源:互联网 发布:c语言for循环语句 编辑:程序博客网 时间:2024/06/15 08:04
今天使用AppServ集成环境下的MySQL进行数据备份,出现一个ERROR,如下:
mysqldump: [ERROR] unknown option '--no-beep'
查询资料,得到一个比较靠谱的说法,如下:
There is a "default" my.ini here: C:\ProgramData\MySQL\MySQL Server 5.7\my.ini.It contains the no-beep option.The MySQL Installer has my.ini templates for various versions in C:\ProgramData\MySQL\MySQL Installer for Windows\Manifest\Templates\, for some reason, all of it contains this option.
The no-beep option causes the mysql command line client not to beep when errors occur.If that's an option you want, it should be in the [mysql] section of your my.cnf [or my.ini]. This error suggests that it's in the [client] section of your my.cnf, which causes [...] to throw the error since the option isn't recognized.Check your my.cnf and either remove the line or place it in the [mysql] section instead of [client] and you should be good.The [client] option group is read by all client programs (but not by mysqld). This enables you to specify options that apply to all clients. For example, [client] is the perfect group to use to specify the password that you use to connect to the server. (But make sure that the option file is readable and writable only by yourself, so that other people cannot find out your password.) Be sure not to put an option in the [client] group unless it is recognized by all client programs that you use. Programs that do not understand the option quit after displaying an error message if you try to run them.
关于解决办法:
Removing my.ini from C:\ProgramData\MySQL\MySQL Server 5.6 solved it for me.关于这个解决方法,被人在下面回复了一句:Not a good idea to remove the my.ini file (我也觉得不怎么好,于是又找方法)
后我利用如下语句进行备份数据,成功备份,但有一个警告,数据无恙,语句如下:
mysqldump --no-defaults -uroot -ppwd -h127.0.0.1 --databases fendao > D:\ksk.txt
上面结论参考于:
https://dev.mysql.com/doc/refman/5.6/en/option-files.html
https://stackoverflow.com/questions/14210769/mysqldump-unknown-option-no-beep
阅读全文
0 0
- MySQL数据备份"--no-beep"异常解决
- windows8.1备份mysql问题(mysqldump: unknown option '--no-beep')
- mysqldump: unknown option '--no-beep'
- mysqldump: unknown option '--no-beep'
- mysqldump: unknown option '--no-beep'
- 【MySQL】Inception备份库表数据中文乱码解决
- No CurrentSessionContext configured 异常解决
- CentOS7下解决yum install mysql-server 异常:No package mysql-server available.问题
- Mysql高性能备份方案解决数据不间断访问(LVM快照方式备份)
- MySQL Slave_IO_Running: NO异常处理
- mysql中备份数据
- mysql数据备份
- MySQL数据备份
- MySQL数据备份
- mysql 定时数据备份
- 备份 mysql数据
- mysql数据备份
- mysql 备份数据
- iOS开发学习笔记之UILabel的使用
- android volley
- 计算机视觉 -- 最优化阈值
- web.xml在web项目中的作用,没有web.xml怎么配置项目
- 八大排序算法实战:思想与实现
- MySQL数据备份"--no-beep"异常解决
- sizeof的基本用法的整理
- 贵安新区飘起“数据云”
- CS231nNeural Networks Part 1: Setting up the Architecture
- 在SpringMVC 中使用 Thymeleaf 模板引擎
- ObjectARX编程(五) ---------符号表中层表的操作
- 如何在linux 下 root用户密码丢失情况下,获得root权限
- 爬取网页的通用代码框架
- PHP7.0 的新特性你知道多少?