Import SQL dump into MySQL
Posted
by BryanWheelock
on Stack Overflow
See other posts from Stack Overflow
or by BryanWheelock
Published on 2009-05-13T17:33:31Z
Indexed on
2010/06/14
0:02 UTC
Read the original article
Hit count: 399
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 < 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 < 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?
© Stack Overflow or respective owner