MYSQL: Restore a database from a mysqldump

Go to the directory that your mysqldump is located and Login:
mysql -u root -p

Create the database container if it down not already exist:
mysql> create database mydb;

Switch to using the database:
mysql> use mydb;

Restore the file:
mysql> source db_backup.dump;