How to Dump Mysql database using Command line?

Question

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'

Check your my.ini or my.cnf file for the --no-beep and remove it. Also remove the space between -p and webchat. — Mark Setchell
– Mark Setchell, Commented Mar 25, 2015 at 11:20
I have no idea where you put it! Surely Windows has some ability to search for a named file... — Mark Setchell
– Mark Setchell, Commented Mar 25, 2015 at 11:34

BabyDuck · Accepted Answer · 2015-03-25 13:15:53Z

1

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.

answered Mar 25, 2015 at 13:15

BabyDuck

1,2491 gold badge9 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Dump Mysql database using Command line?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related