CODEWITHSUNDEEP
mysqlphpmyadmin
user715564
user715564

Reputation: 1690

Database import error

I am trying to import a database but I keep getting an error. Could anyone tell me what this means?

database error

Upvotes: 0

Views: 818

Answers (3)

Rohit Choudhary
Rohit Choudhary

Reputation: 2269

Create a database name nspire_wrdp2 then import.

Upvotes: 0

jcmeloni
jcmeloni

Reputation: 1234

If you are using PHPMyAdmin and have gone directly to the Import tab without first selecting a database from the column on the left, you will get this error. You can tell if you haven't selected a database because the page heading will say "Importing into the Current Server" rather than "Importing into the database databasename".

In PHPMyAdmin, go to the database list in the column on the left, click on one to select, then click the import tab and upload your file.

Note: this clicking action performs the same function as the MySQL query USE databasename, which you could also just add to the SQL dump you are importing.

Upvotes: 1

kingjeffrey
kingjeffrey

Reputation: 15250

You are trying to create a table, but have not said what database you want to create a table in. Try manually creating an empty database, and create the table in that.

Upvotes: 1

Related Questions