Saturday, February 18, 2017

How to import MySQL database from command prompt

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

No comments :

Post a Comment