mysql import sql console code example
Example 1: mysql import sql file
mysql -u username -p database_name < file.sql
Example 2: mysql import from sql file
mysql -u username -p database_name < file.sql
; OR
mysql> use db_name;
mysql> source file_name.sql;
Example 3: import DB through mysql console
mysql> use db_name;
mysql> source folder_path/file_name.sql;
Example 4: import DB through mysql console
mysql> use db_name;
mysql> source file_name.sql;