CODEWITHSUNDEEP
mysql
Abhishek
Abhishek

Reputation: 1837

How to properly dump mysql database via mysqldump?

Does mysqldump utility requires any seperate client ??

I'm using MYSQL5.5 command line client for windows..

I'm writing query 

mysqldump -u root -p pwd** my_db > mydb.sql

I'm getting the error 

  ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t

Upvotes: 0

Views: 526

Answers (3)

Lynn Crumbling
Lynn Crumbling

Reputation: 13367

The problem is that you're running the command in the MySQL command line client. Run it from a shell instead, not inside of the client.

In other words, open a normal shell (cmd.exe if using Windows), and run: (your path to mysqldump.exe will no doubt differ)

C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump -u root -ppwd** my_db > mydb.sql

Do not open up the MySQL command line client and run that command inside of there. That client is for executing SQL; the mysqldump.exe program is completely separate and runs on its own.

Upvotes: 2

Slowcoder
Slowcoder

Reputation: 2120

mysqldump -u root -p pwd** my_db > mydb.sql

Upvotes: 0

Tyler Eaves
Tyler Eaves

Reputation: 13133

> not <

You're dumping the file mysql.sql INTO mysqldump, not out of it

Upvotes: 0

Related Questions