Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

mysqldump unknown option no beep

I'm running MySQL 5.5 on Windows, attempting a mysqldump:

 "C:\WebServer\MySQL Server 5.5\bin\mysqldump.exe" -u user -ppassword database > "C:\backup.sql" 

But get error:

mysqldump: unknown option '--no beep'

This is a pretty basic command, and works on two other development boxes, so not sure what is causing this?

like image 908
JustBaron Avatar asked Jan 08 '13 08:01

JustBaron


2 Answers

Same issue, commented out (#) the no-beep line in the MySQL my.ini, solved the problem.

like image 115
Matt Avatar answered Sep 21 '22 22:09

Matt


I found this answer on dba.stackexchange.com, which is very helpful:

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.

-- http://dev.mysql.com/doc/refman/5.6/en/option-files.html

like image 22
naitsirch Avatar answered Sep 24 '22 22:09

naitsirch