bash> mysqldump -u root -p [database name] >file.sql ## dump dhe database
mysql> create database [database name]; ## create the database
mysql> use [database name]; ## select the database
mysql> source file.sql; ## import the database

peshka's reminder site – ver. 2.0
bash> mysqldump -u root -p [database name] >file.sql ## dump dhe database
mysql> create database [database name]; ## create the database
mysql> use [database name]; ## select the database
mysql> source file.sql; ## import the database