Mysql import from a SQL file by command line way

Mysql import from a SQL file by command line way:

Open command line and login to your mysql database by typing below command:

mysql -u root -p password then press enter.

mysql > source path_of_your_sql_file.sql Eg: if your file in D drive then path will be D:\mysql.sql

Then press enter all your tables will be imported soon.