Newsletter signup

mysqldump: unknown option ‘–no-beep’

Here’s a great gotcha!

I’ve just upgraded my Windows test server to run MySQL Community edition 5.6.25

I have a script which runs daily to dump some of the database files from test website. The command used is MySQLDump and each dump is performed using a line of script something like this

mysqldump -u username -ppassword database_table_name >dump_file_name.sql

When I ran the script manually I was surprised to find it ran rather quickly, so I opened a command window and ran one of the lines manually

I got the error message

mysqldump: unknown option ‘–no-beep’

I tried again – this time with just the mysqldump and got the same error

After a bit of Googling where I found this article from StackOverflow – What’s wrong with mysqldump? – which explained that I’d put the “no-beep” in the my.cnf configuration file under the [client] section, which applies to both mysql and mysqldump clients, and that I should have put it in the [mysql] section of the config file, so it applies only to the mysql client.

So off I went to have a look at the my.cnf file and yes – no-beep was immediately below the [client] line. Moving it to below [mysql] fixed this (Phew – I can backup my test databases again). The however is – however, I never put it there, it was there in the install files.

Oh well – it looks like Microsoft aren’t the only people to release buggy software 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

What we're tweeting
Categories