mysql -u username -p new_database < data-dump.sql
NOTE: You may first need to create the database itself, it the dump file does not include this.
CREATE DATABASE new_database;
The successfully-run command will produce no output, unless an error occurs.