Mysql error 1046, Can someone help me out?

Hi everyone!

 I need to import the file into my local host joomla installation. But  it's something is not cooperating. This is the error I'm receiving:

SQL query:

Table structure for table `bak_banner`

DROP TABLE IF EXISTS `bak_banner` ;

MySQL said: Documentation

#1046 - No database selected

0 Comments   [ + ] Show comments

Answers (4)

Answer Summary:
Posted by: MichielTelmans 9 years ago
White Belt

For the database import, before you attempt to importthe "flat" file data in, you need go to your local DB (MySQL) andcreate new database After that you can import!

also read info here  http://www.filerepairforum.com/forum/databases/databases-aa/mysql/713-%E2%80%8Bhow-to-fix-a-corrupted-server-configuration-in-mysql

Posted by: EdT 9 years ago
Red Belt
Also, the clue was in the error message "No database selected".  Don't ignore error messages as despite the poor standard of many programs, in general they do tend to give you some useable information most of the time.
Posted by: MichielTelmans 9 years ago
White Belt
Posted by: anonymous_9363 9 years ago
Red Belt
Heard of Google? I have.

DROP TABLE IF EXISTS `dbName`.`tableName`
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ