import mysql cmd code example

Example 1: mysql import sql file

mysql -u username -p database_name < file.sql

Example 2: mysql load sql from file

mysql> use db_name;
 mysql> source file_name.sql;

Example 3: import mysql database command line linux

mysql -u<user_name> -puser_password> <database_name>
source /path/db.sql

Example 4: mysql import command windows

C:\wamp\bin\mysql\mysql5.0.51b\bin>mysql -u root -p YourDatabaseName < YourFileName.sql