How do I open an sql database that I downloaded using the terminal?

How can I import a database with MySQL from terminal? the syntax from this thread

mysql -u username -ppassword databasename < filename.sql

my input for the file (lahman591) i placed on my root for simplicity sake

mysql> mysql -u root -p lahman591 <c:\lahman591.sql

i get an Error:

ERROR 1064 (42000) You have an error in your sql syntax.

Answers


You need to do it from your normal shell (the command is calling the mysql bin), not mysql shell.


Need Your Help

NSString from NSData always null

objective-c macos sha hmac nsstringencoding

I would like to sign a request with HMAC SHA512, but I seem to mess up encoding and decoding from and to NSData and NSString. I desperately tried to figure out what is wrong, but I just don't seem ...

Unable to set ComboBox.RowSource on continuous form

ms-access vba continuous-forms

I am having trouble setting the row source of a certain combo box on my form (viewed as a continuous form, although I also seem to have some problems in single-form mode).