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


How to Import sql dump file via MySQL command line ?