Software Question

Mysql error 1046, Can someone help me out?

02/13/2015 2975 views

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

Answer Summary:
0 Comments   [ + ] Show comments


Community Chosen Answer


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

Answered 02/15/2015 by: MichielTelmans
White Belt

All Answers

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.
Answered 02/16/2015 by: EdT
Red Belt

Answered 02/15/2015 by: MichielTelmans
White Belt

Heard of Google? I have.

DROP TABLE IF EXISTS `dbName`.`tableName`
Answered 02/16/2015 by: anonymous_9363
Red Belt

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