Sometimes when you have large databases files and you are unable to import the database manually. Then the easiest (and fastest) way is to use command line.
1. Run the cmd (DOS) and get into the mysql folder, which in my case works like this
2. Then use this command to run up MySQL
C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql.exe -use databasename -u username -p password_optional
To make things easier, I copy my SQL file into the C derive. And then run following command
mysql> source C:/myfilename.sql;
You can put the SQL file anywhere in your system and give the source file path.