MySQL dump command not working
Last post Mar 04, 2016 06:30 AM by Jean Sun
Mar 04, 2016 12:52 AM|gc83|LINK
I am trying to use the MySQL dump command to export a database file to upload to my hosting site. This is the command that I am using:
mysqldump -u username -ppassword databasename > dumpfile.sql
I get this error message:
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 'mysqldump -u username -ppassword databasename > dumpfile.sql' at line 1
What am I doing wrong?
Thanks in advance!
Mar 04, 2016 01:03 AM|lextm|LINK
MySQL has its own support channel,
Or you might post to http://stackoverflow.com
This is a forum dedicated to IIS.
Mar 04, 2016 06:30 AM|Jean Sun|LINK
You can try removing the space between -u and username. Or try use absolute file path of dumpfile.sql.
mysqldump -uusername -ppassword databasename > [Absolute-Path]\dumpfile.sql