Andrew
Andrew

Reputation: 6394

Import sql dump

I'm trying to import an sql dump into mysql. I selected in command prompt the directory where the file is and I'm using the following command( from inside the file's directory):

mysql -u root -p password database < file.sql  

It doesn't show any specific detail regarding this, it just shows the list of all the options I have, like in a help. I'm not an advanced user of mysql, maybe you have an idea why it isn't working. Thanks.

Upvotes: 1

Views: 555

Answers (1)

Michael Berkowski
Michael Berkowski

Reputation: 270617

Place the password immediately after -p. Also, you misspelled mysql:

mysql -u root -ppassword database < file.sql  

Upvotes: 3

Related Questions