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:

code format="mysql" mysql -u  -p code The above command will ask you for the password of the corresponding 

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

4) At last use the MySQL command code format="mysql" SOURCE  code to import your database into the "testdb" database.