I&#39;m confused how to import a SQL dump file.  I can&#39;t seem to import the database without creating the database first in MySQL.

This is the error displayed when `database_name` has not yet been created: 

`username` = username of someone with access to the database on the original server.  
`database_name` = name of database from the original server 

&lt;!-- language: none --&gt; 

    $ mysql -u username -p -h localhost database_name &lt; dumpfile.sql   
    Enter password:  
    ERROR 1049 (42000): Unknown database &#39;database_name&#39; 

 

If I log into MySQL as root and create the database, `database_name` 
 
    mysql -u root  
    create database database_name;  
    create user username;# same username as the user from the database I got the dump from.  
    grant all privileges on database_name.* to username@&quot;localhost&quot; identified by &#39;password&#39;;  
    exit mysql

then attempt to import the sql dump again:  

    $ mysql -u username -p database_name &lt; dumpfile.sql  
    Enter password:  
    ERROR 1007 (HY000) at line 21: Can&#39;t create database &#39;database_name&#39;; database exists

How am I supposed to import the SQL dumpfile?

All Mysql Error-1049 Solutions on Gang of Coders

Total of 1 Mysql Error-1049 Solutions

Error importing SQL dump into MySQL: Unknown database / Can't create database