Syntax error in mysqldump command

Question

mysqldump mydatabase < /my/path/to/sqlfile.sql;

This is my command issued. What could be the cause of this syntax error, i'm pretty sure its correct.

I am trying to load an sql file to my database.

Plese check the syntax in my answer! – Digital Alchemist Aug 29 '13 at 05:00 — Digital Alchemist, Aug 29 '13 at 05:00
It would be nice to accept the most-upvoted answer! – rioted Apr 03 '17 at 11:51 — rioted, Apr 03 '17 at 11:51

score 8 · Answer 1 · edited Mar 07 '14 at 20:55

8

use

mysqldump -u username -p databasename > filename.sql

to export and

mysql -u username -p databasename < filename.sql

to import

Please refer: http://dev.mysql.com/doc/refman/5.6/en/mysqldump.html

edited Mar 07 '14 at 20:55

Brad Larson

170,088
45
397
571

answered Aug 29 '13 at 05:01

Sathish D

4,854
31
44

score 2 · Answer 2 · answered Aug 29 '13 at 05:05

2

Synatax of MySQL dump command is : mysqldump -u -p >

In your case if the username is root then : mysqldump -u root -p mydatabase > /my/path/to/sqlfile.sql;

answered Aug 29 '13 at 05:05

PSSR

471
1
10
18

score 1 · Answer 3 · answered Aug 29 '13 at 04:57

1

This might work out!

backup: # mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

restore:# mysql -u root -p[root_password] [database_name] < dumpfilename.sql

example

mysql -u root -ptmppassword databaseName < /tmp/fileName.sql

answered Aug 29 '13 at 04:57

Digital Alchemist

2,324
1
15
17

Syntax error in mysqldump command

3 Answers3

Linked