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.