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 > 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)


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