blocks|key|202299|text|环境变量或my.cnf文件中的内容？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|202300|无论如何，当我将no-beep选项(对于mysql客户机有效，但对于mysqldump无效)放在配置文件的[client]部分时，我得到|offset|length|style|CODE|202301|mysqldump:+unknown+option+'--no-beep'|code-block|syntax|javascript|202302|(正如在naitsirch's+answer中提到的，它应该从[client]部分移到[mysql]部分，这样它就不会尝试将它用于其他客户端程序，比如mysqldump。)|202303|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/a/26461338/17389^0|0|1H|8|0|0|V|8|17|7|4|I|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|11|8|@$D|12|E|13|F|G]|$D|14|E|15|F|G]]|9|@$D|16|E|17|1|18]]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

Something in an environment variable or my.cnf file?

For what it's worth, when I put the no-beep option (a valid option for the mysql client, but not for mysqldump) in the <code>[client]</code> section of my config file, I get 

<pre><code>mysqldump: unknown option '--no-beep'
</code></pre>

(As mentioned in <a href="https://stackoverflow.com/a/26461338/17389">naitsirch's answer</a>, it should be moved from the <code>[client]</code> section to the <code>[mysql]</code> section so it doesn't try to use it for other client programs such as mysqldump.)

blocks|key|202802|text|与此相关的一点是，您必须了解已安装的各种MySQL产品。下面的场景最好地解释了这一点。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|202803|202804|C:\Program+Files\+MySQL+\MySQL+5.5\my.ini+(创建自以前的|unordered-list-item|202805|\MySQL\MySQL+5.5\my.ini+5.6\my.ini+(有人将此复制到此处，谁知道why)|202806|C:\Program+Files\MySQL\my.ini+(由MySQL+Installer配置向导创建))|202807|202808|202809|因此，您可能会假设MySQL工作台从您正在使用的MySQL版本中的my.ini文件中提取设置。这将是一个安全的假设，因为在工作台中设置用于管理的配置需要指向特定于该安装的my.ini。然而，这是不正确的，因为我发现它锁住了位于C:\Program+Files\MySQL\my.ini的那个，作为要使用的那个。因此，您必须编辑此文件以使工作台正常工作。|offset|length|style|CODE|202810|entityMap^0|0|0|1|1|1|0|0|X|6|2D|6|35|T|0^^$0|@$1|2|3|4|5|6|7|T|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|U|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|V|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|10|8|@$N|11|O|12|P|Q]|$N|13|O|14|P|Q]|$N|15|O|16|P|Q]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|S|$]]

One note relating to this, you have to be aware of your various installed MySQL products. The following scenario best explains it.

<ul>
<li>C:\Program Files\MySQL\MySQL Server 5.5\my.ini (created from a previous installation)</li>
<li>C:\Program Files\MySQL\MySQL Server 5.6\my.ini (someone copied this here, who knows why)</li>
<li>C:\Program Files\MySQL\my.ini (created by MySQL Installer Config Wizard)</li>
</ul>

So you might assume that the MySQL Workbench draws settings from the <code>my.ini</code> file inside of the MySQL version you're working against. This would be a safe assumption as part of setting up a configuration for administration in the Workbench requires pointing to the <code>my.ini</code> specific to that installation. However that is incorrect as I've found it latches onto the one located at <code>C:\Program Files\MySQL\my.ini</code> as the one to use. You thus have to edit this file to get the Workbench to function correctly.

blocks|key|202825|text|同样的问题，在MySQL+my.ini中注释掉(#)无蜂鸣音行，解决了问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|202826|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

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

blocks|key|202838|text|我在dba.stackexchange.com上找到了this+answer，这很有帮助：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|202839|202840|+no-beep+option导致mysql命令行客户端在发生错误时不发出蜂鸣音。|blockquote|style|CODE|202841|202842|如果这是你想要的选项，它应该在你的my.cnf或my.ini的[mysql]部分。此错误表明它位于my.cnf的[client]部分，这会导致...抛出错误，因为该选项无法识别。|202843|检查您的my.cnf，或者删除该行，或者将它放在[mysql]部分而不是[client]部分，这样就可以了。|202844|客户端选项组可由所有客户端程序读取(但不能由mysqld读取)。这使您能够指定适用于所有客户端的选项。例如，客户端是用于指定用于连接到服务器的密码的完美组。(但请确保选项文件只对您自己可读和可写，以便其他人找不到您的密码。)请确保不要在客户端组中放置选项，除非您使用的所有客户端程序都能识别该选项。如果您尝试运行不理解该选项的程序，则会在显示错误消息后退出。--+http://dev.mysql.com/doc/refman/5.6/en/option-files.html|202845|entityMap|0|LINK|mutability|MUTABLE|url|https://dba.stackexchange.com/questions/30667/unknown-option-no-beep|1|http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_no-beep|2|http://dev.mysql.com/doc/refman/5.6/en/option-files.html^0|R|B|0|0|0|1|7|H|5|9|6|1|0|0|H|6|V|7|1D|6|1K|8|0|4|6|O|7|10|8|0|52|1K|2|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|-4|5|6|7|16|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|17|8|@$A|18|B|19|H|I]|$A|1A|B|1B|H|I]]|9|@$A|1C|B|1D|1|1E]]|C|$]]|$1|J|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|1G|8|@$A|1H|B|1I|H|I]|$A|1J|B|1K|H|I]|$A|1L|B|1M|H|I]|$A|1N|B|1O|H|I]]|9|@]|C|$]]|$1|M|3|N|5|6|7|1P|8|@$A|1Q|B|1R|H|I]|$A|1S|B|1T|H|I]|$A|1U|B|1V|H|I]]|9|@]|C|$]]|$1|O|3|P|5|6|7|1W|8|@]|9|@$A|1X|B|1Y|1|1Z]]|C|$]]|$1|Q|3|-4|5|6|7|20|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]|Y|$5|T|U|V|C|$W|Z]]|10|$5|T|U|V|C|$W|11]]]]

I found <a href="https://dba.stackexchange.com/questions/30667/unknown-option-no-beep">this answer</a> on dba.stackexchange.com, which is very helpful:

<blockquote>
 The <code>no-beep</code> <a href="http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_no-beep" rel="noreferrer">option</a> causes the <code>mysql</code> command line client not to beep when errors occur.
 
 If that's an option you want, it should be in the <code>[mysql]</code> section of your <code>my.cnf</code> [or my.ini]. This error suggests that it's in the <code>[client]</code> section of your <code>my.cnf</code>, which causes [...] to throw the error since the option isn't recognized.
 
 Check your <code>my.cnf</code> and either remove the line or place it in the <code>[mysql]</code> section instead of <code>[client]</code> and you should be good.
 
 <blockquote>
 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.
 </blockquote>
 
 -- <a href="http://dev.mysql.com/doc/refman/5.6/en/option-files.html" rel="noreferrer">http://dev.mysql.com/doc/refman/5.6/en/option-files.html</a>
</blockquote>

blocks|key|202861|text|尽管在mysql服务的属性中指定的my.ini文件的客户机节中删除了-no--beep选项，但问题仍然存在。MYSQL56服务设置使用E:\Program+Data\MySQL\MySQL+Server5.6\中的my.in。这个ini文件在client部分下面有no+-no--beep选项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|202862|那么问题出在哪里呢？|202863|在我的设置中，mysqldump.exe驻留在C:\Program+Files\MySQL\MySQL+Server5.6\bin中。当将其作为命令行选项运行时，mysql使用C:\Program+Files\MySQL\MySQL+Server+5.6\my.ini。此ini文件中包含no--beep选项。mysqldump使用的不是服务指定的my.ini，而是上一个目录。|202864|删除C:\Program+Files\MySQL\MySQL+Server+5.6\my.ini可以解决这个问题。|202865|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Despite removing the -no--beep otion from the client section in the my.ini file specified in the properties of the mysql service, the problem persisted. The MYSQL56 service set up was using my.in from E:\Program Data\MySQL\MySQL Server 5.6\ . And this ini file had no -no--beep option under the [client] section.

So what was the problem?

In my setup, mysqldump.exe is residing at C:\Program Files\MySQL\MySQL Server 5.6\bin. When running this as a command line option, mysql was using C:\Program Files\MySQL\MySQL Server 5.6\my.ini. This ini file contained the no--beep option in it. mysqldump was not using the my.ini specified by the service but rather the one directory up.

Deleting C:\Program Files\MySQL\MySQL Server 5.6\my.ini solves the problem.

blocks|key|199971|text|从C:\ProgramData\MySQL\MySQL+Server+5.6中删除my.ini为我解决了这个问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|199972|entityMap^0|1|11|15|6|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

Removing <code>my.ini</code> from <code>C:\ProgramData\MySQL\MySQL Server 5.6</code> solved it for me.

blocks|key|2834880|text|删除no-beep选项对我有效，但我必须更改windows目录中的my.ini文件！顺便说一下，我用的是Windows10。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2834881|entityMap^0|X|T|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Deleting the no-beep option worked for me, but I had to change the my.ini file in my windows directory! 
I'm using windows 10 by the way.

blocks|key|2834887|text|替代解决方案是使用--no-defaults选项|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2834888|例如：mysqldump+--no-defaults+-u+root+-p+[DB_NAME]+>+[FILE_NAME].sql|2834889|entityMap^0|9|D|0|3|1Q|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|P|8|@]|D|@]|E|$]]]|I|$]]

Alternate solution is to use <code>--no-defaults</code> option 

Eg : <code>mysqldump --no-defaults -u root -p [DB_NAME] &gt; [FILE_NAME].sql</code>

blocks|key|202891|text|我也解决了这个问题|type|unstyled|depth|inlineStyleRanges|entityRanges|data|202892|C:\ProgramData\MySQL\MySQL+Server+8.0|202893|重启pc|202894|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|H|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|I|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|J|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|G|$]]

solved it for me too

C:\ProgramData\MySQL\MySQL Server 8.0

reboot pc

blocks|key|2834914|text|如果你也面临着同样的-无蜂鸣音-问题，那么解决方案就很简单了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2834915|然后只需按下windows按钮并搜索mysql安装程序社区，您就会在mysql服务器的链接上找到一个重新配置选项。|2834916|只需单击它并执行以下几个步骤，然后通过打开命令提示符并输入mysql+-u+root+-p来测试是否已完成|2834917|并键入root密码|2834918|我希望这也会对你们有帮助，因为我发现它是我自己试图解决的|2834919|之所以会产生这个问题，是因为mysql数据库之间没有建立连接，所以我们只是发起了一个连接，从而使其正常运行|2834920|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

The solution is very easy
If you are also facing the same ---no beep--- problem
Then simply press the windows button and search for mysql installer community
over there you will find an option of reconfigure on the link of mysql server
Just click on it and follow the few steps and after that test if its done by opening the command promp and type mysql -u root -p
and type the root password
I hope this would also be helpful for you guys as I found it bymyself trying to solve
This problem was generated because there was no connection established between mysql databases so we just initiated a connection and thus made it run as usual

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

<pre><code> "C:\WebServer\MySQL Server 5.5\bin\mysqldump.exe" -u user -ppassword database &gt; "C:\backup.sql"
</code></pre>

But get error: 

<blockquote>
 mysqldump: unknown option '--no beep'
</blockquote>

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

mysqldump unknown option no beep

SQL Server

数据库

服务器

MySQL

我在Windows5.5上运行MySQL，尝试使用mysqldump： "C:\WebServer\MySQL Server 5.5\bin\mysqldump.exe" -u user -ppassword database > "C:\backup.sql"但是get错误： mysqldump:未知选项'--no ...

问mysqldump未知选项无蜂鸣音
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqldump未知选项无蜂鸣音EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysqldump未知选项无蜂鸣音
EN