How to Import Mysql database with use of command line?

I am explaining you, how to Import Mysql database with use of command line.
When you have large size of database then you can not easily import from phpmyadmin. so you need to use mysql import command for it. so here I am writing simple command to import large size database using command in ubuntu.

Syntax :

D:/xampp>mysql>bin
mysql -u root -p database_name < "E:\projects\data\databasefilename.sql"

Leave a Reply

Your email address will not be published. Required fields are marked *

5 + 1 =