Here’s how to restore a MySQL database from mysqldump.

<pre lang="bash">
mysql -u user -p
mysql> drop database databasename;
mysql> quit;
Bye
mysql -u user -p databasename 



<p>Drop database first, then import the SQL file.</p>