How to import MySQL database from command prompt

How to import mysql database from command prompt is easy. sometime it use for big database and problem with phpMyAdmin. But if you have SQL Remote Client you can used that to import database.

to import from command prompt, first you must go to folder mysql instaled. got to bin folder and type this command

mysql -u your_mysql_username_here -p name_of_database < file_dump_here.sql

and than type your mysql password