MySQL Forums
Forum List  »  Oracle

Copying mysql database to a file
Posted by: Zulfi Khan
Date: November 03, 2014 11:32AM

I want to copy mysql database to a file. I am using following command but its giving me an error:
mysql> mysqldump -u root -pzulfi12345 ssuetinfo_73_86_97_99_2014 > ssuetinfo.sql
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 to use near 'mysql
dump -u root -pzulfi12345 ssuetinfo_73_86_97_99_2014 > ssuetinfo.sql' at line 1

Also guide where ssuetinfo.sql file would be stored in my harddisk.


Options: ReplyQuote

Written By
Copying mysql database to a file
November 03, 2014 11:32AM

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.