We are hiring PHP Web Developers (0-2 exp), Please visit career page for more information.

It is very simple to import the .sql file, which is taken as backup from phpMyAdmin or from some other hosting control panel.

If it is small file, then it is easy to import via import option in phpMyAdmin area, but some times it is hard to import large files, it would take too much of time or it may stop to import in middle.

So the command line import options is quit easy and fast comparing with other options. Here is an example that how to import via command line.

mysql > use YOUR DATABASE NAME
mysql > source PATH OF YOUR DUMP .SQL FILE

after you would see series of lines run bottom like this
Query OK, 0 rows affected (0.00 sec)

Example

mysql > use employer
mysql > source D:/wamp/www/project/emp.sql

 

How to Import sql dump file via MySQL command line ?