import mysql dump command line code example
Example 1: mysql import sql file
mysql -u username -p database_name < file.sql
Example 2: linux command line import mysql database
# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.sql
Example 3: database dump mysql command
mysqldump -u username -p dbname > filename.sql
Example 4: import mysql command line without database
mysql -u username -p database_name < file.sql
Note-1: It is better to use the full path of the SQL file file.sql.
Note-2: Use -R and --triggers to keep the routines and triggers of original database.
They are not copied by default.
Note-3 You may have to create the (empty) database from mysql if it
doesn't exist already and the exported SQL don't
contain CREATE DATABASE (exported with --no-create-db or -n option),
before you can import it.
Example 5: import mysql dump command line
mysql -u username -p database_name < file.sql
Example 6: import mysql dump command line
mysql> use db_name;
mysql> source backup-file.sql;