Recovering MySQL database from Backup

This assumes you have a fresh system running MySQL with no
existing databases.

$ mysql
mysql> create database cooldb;
mysql> \q

$ mysql cooldb < cooldb.sql


Archiving MySQL database to a set of backup files

$ mysqldump -u root --opt cooldb > cooldb.sql