Can't import MySQL database due to syntax error

Question

But why? I've imported it in OS X and on another Linux machine, this one however plain refuses..

Where am I going wrong?

Output:

mysql> mysql -u root -p explore < /tmp/explore.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 -u root -p explore < /tmp/explore.sql' at line 1

Pablo Santa Cruz · Accepted Answer · 2010-11-30 13:10:53Z

5

You are trying to run a shell command from the MySQL command line interpreter. You need to run that from BASH (or any other shell), no the MYSQL command prompt.

Like this in Linux:

$ mysql -u root -p explore < /tmp/explore.sql;

Like this in Windows:

C:\> mysql -u root -p explore < c:\tmp\explore.sql;

answered Nov 30, 2010 at 13:10

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mantar Over a year ago

That... Didn't make sense to me. It was, however, as simple as that. Thanks. :)

Shakti Singh · Accepted Answer · 2010-11-30 13:19:25Z

1

try to execute this

source /tmp/explore.sql;

after logging in mysql prompt

or

get out from the mysql prompt you are already there and run the command you are trying. Thanks

edited Nov 30, 2010 at 13:19

answered Nov 30, 2010 at 13:11

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

Collectives™ on Stack Overflow

Can't import MySQL database due to syntax error

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related