how to import a database dump into mysql code example
Example 1: linux command line import mysql database
# if your database is not locally hosted
mysql -u username -p -h dbhost dbname < filename.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;