MySQL import dump

To import database from a dumped sql file:

• Login to mysql


• Create database with the specific name:
  
  
create database database_name;

  


• Exit mysql.


• Import the contents of the database from a file:
  
mysql -u user -p database_name < database_dump.sql