mysql import dump code example
Example 1: mysql import sql file
mysql -u username -p database_name < file.sql
Example 2: dump mysql
mysqldump -u username -p database_name > data-dump.sql
Example 3: linux command line import mysql database
mysql -u username -p -h dbhost dbname < filename.sql
Example 4: import mysql dump command line
mysql -u username -p database_name < file.sql
Example 5: mysql load sql from file
mysql> use db_name;
mysql> source file_name.sql;
Example 6: how to import mysql database command line
mysql>create database yourDatabaseName;
mysql>use yourDatabaseName;