Error importing SQL dump into MySQL Unknown database Can t create database

Question

I m confused how to import a SQL dump file   I can 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     mysql -u username -p -h localhost database name  lt  dumpfile sql    Enter password    ERROR 1049  42000   Unknown database  database name     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  localhost  identified by  password     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 t create database  database name   database exists   How am I supposed to import the SQL dumpfile

User · Answer

It sounds like your database dump includes the information for creating the database   So don t give the MySQL command line a database name   It will create the new database and switch to it to do the import

User · Answer

Open the sql file and comment out the line that tries to create the existing database

User · Answer

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    first start your MySQL command line  apply username and password if you need to  C   gt mysql -u user -p Create your database and exit    mysql gt  DROP DATABASE database    mysql gt  CREATE DATABASE database    mysql gt  Exit    Import your selected database from the dump file C   gt mysql -u user -p -h localhost -D database -o  lt  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

User · Answer

I create the database myself using the command line  Then try to import again  it works

User · Answer

If you create your database in direct admin or cpanel  you must edit your sql with notepad or notepad   and change CREATE DATABASE command to CREATE DATABASE IF NOT EXISTS in line22

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

Examples related to mysql

Examples related to sql

Examples related to mysqldump

Examples related to mysql-error-1049

Examples related to mysql-error-1007