Mysql 1046 error

1.3k views Asked by At

I've started a new Wordpress site, and and trying to import a database form a site I had about 3 years ago. Whenever I click on import, choose the file and set it away, I get this error:

Error

SQL query: 

--
-- Table structure for table `wp_commentmeta`
--
DROP TABLE IF EXISTS `wp_commentmeta` ;

MySQL said:  
 #1046 - No database selected

I've tried a few fixes such as setting the Do not use auto interrupt to off, unticking allow interruption, setting the compatibility mode and changing the character set but nothing seems to work. I did import this file into another Wordpress blog about a year ago, so I know it worked then, but it's refusing now.

This is the phpmyadmin version:

Server: 109.68.38.30 via TCP/IP
Server version: 5.1.52
Protocol version: 10
User: [email protected]
 MySQL charset:  UTF-8 Unicode (utf8)

I hope someone will be abel to help here.

1

There are 1 answers

0
ganesh On

try following query to select database and then check

USE database_name;