MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

mysqldump
Posted by: Glen Miller
Date: February 27, 2014 06:10AM

I'm at mysql> prompt & trying to run mysqldump command to backup a database, but it doesn't work:

mysql>dump -u root -p***** tickets > test.sql
or
mysql>mysqldump -u root -p****** tickets > test.sql

both met with ERROR 1064 - error in SQL syntax ?

Actually - I find the answer : To run fro C:\ prompt the mysqldump command !!!



Edited 1 time(s). Last edit at 02/27/2014 06:44AM by Glen Miller.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
mysqldump
Glen Miller
February 27, 2014 06:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.