MySQL - How to restore a dump file (command-line)

/usr/local/mysql/bin/mysql -u root -p
mysql> create database DATABASE_NAME;
mysql> use DATABASE_NAME;
mysql> source DUMP_FILE_NAME.dmp;


Substitute "root" with a more appropriate user, if any.