Logicbomb
Logicbomb

Reputation: 541

How to Dump Mysql database using Command line?

When I tried to dump database using command line, it gave me following error.

Command:

D:\TOOLS\MySQL\MySQL Server 5.6\bin>mysqldump -u root -p webchat > tut_backup.sql

Error:

mysqldump: unknown option '--no-beep'

Upvotes: 0

Views: 168

Answers (1)

BabyDuck
BabyDuck

Reputation: 1249

Add host-name in your command, like:

D:\TOOLS\MySQL\MySQL Server 5.6\bin>mysqldump -h localhost -u root -p webchat > tut_backup.sql

Replace localhost with your host-name if it is different.

I consider webchat is your database name and you will have to type password explicitly after firing this command. And of course you have to remove --no-beep (as suggested by Mark Setchell ) from mysql configuration file.

Hope it helps, thanks.

Upvotes: 1

Related Questions