0

I was trying to backup a database with the name test.
I got the error as below:

ERROR 1064 (42000): You have an error in your SQL syntax; check......

This error occurred when I am executing (command line)
mysql> mysqldump -u root -p password test > test.sql;

How could this be solve?

2
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by Derice
0

Where should I point my command line to?
Is it suppose to be C:\> instead of mysql> ?

0

Thanks for the reply... I figured it out how I am suppose to run the command! :)

In my case, it is C:\xampp\mysql\bin>. The folder than contain mysqldump.exe

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.