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

by

This is a known bug at MySQL.

bug 42996
bug 40477

As you can see this has been a known issue since 2008 and they have not fixed it yet!!!

WORK AROUND
You first need to create the database to import. It doesn’t need any tables. Then you can import your database.

  1. first start your MySQL command line (apply username and password if you need to)
    C:\>mysql -u user -p

  2. Create your database and exit 

    mysql> DROP DATABASE database;  
mysql> CREATE DATABASE database;  
mysql> Exit

  3. Import your selected database from the dump file
    C:\>mysql -u user -p -h localhost -D database -o < dumpfile.sql

You can replace localhost with an IP or domain for any MySQL server you want to import to.
The reason for the DROP command in the mysql prompt is to be sure we start with an empty and clean database.

Leave a Comment

tech