How to Import Big MySQL Dump file

1) Create an empty database (I do it using phpmyadmin) - For this example lets assume that we created a database named "testdb"

2) Go to the terminal window and run the following command to enter the MySQL command line:

mysql -u <MySQL-User> -p
The above command will ask you for the password of the corresponding <MySQL-User>

3) Since you enter the MySQL prompt enter the command
USE testdb
to select the database we created in the first step.

4) At last use the MySQL command
SOURCE <mysql-dump.sql>
to import your database into the "testdb" database.