mysqldump - mysql dump issue

Question

mysql gives me the syntax error with the following line... i dont know what is wrong with this...

mysqldump -u root -p root mydatabase > dumpfile.sql

i am using windows vista...

plz help here.. thnx..

Answer 1

Make sure that you are running this from the normal command line and not within the mysql command line. So like this:

C:[path to mysqldump app] > mysqldump -u root -p root mydatabase > dumpfile.sql

not

mysql > mysqldump -u root -p root mydatabase > dumpfile.sql