Importing .sql file
Posted on 2011-05-12
I have set up a local instance of My SQL to do some testing and data export functions with an existing database.
However when I try to restore the .sql file into this instance, I'm having all kinds of issues, but bottom line, I'm not getting any response from the Command Line Client, including no errors. Just sits there.
I have to use Command Line because the database is about 120 MB and Heidi SQL barfs during import with Out of Memeory errors.
So here is my syntax. What am I doing wrong?
mysql> mysql -u spw_web_user -p password spw_online <spw_online_may_11_2011.sql
After I hit Enter I just get: