distal-attribute
distal-attribute
distal-attribute
distal-attribute

Database cannot be deleted -- SQL Error 1049: Unknown database

User, date Message
Written by WaveLength
1 year ago
Category: General
11 posts since Thu, 07 Jul 11
When I go to localhost, a database called test1 is listed in the left panel. I want to drop it, but when I click on it, I get this error message:

SQL Error (1049): Unknown database test1

If I run

drop database test1

then I get error 1008 ("database doesn't exist")

I have several of these fantom databases, and I'd like to delete them. Is there any way to do that?

Thanks.


Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
Do these databases show up in a SHOW DATABASES query result?
Written by WaveLength
1 year ago
11 posts since Thu, 07 Jul 11
No, they do not appear after a SHOW DATABASES query.
Written by WaveLength
1 year ago
11 posts since Thu, 07 Jul 11
I solved the problem, as follows:

Open the Session Manager, select localhost, choose an individual database from the Databases drop-down list, click save, click cancel, exit HeidiSQL, reopen HeidiSQL, select localhost, click Open. The phantom databases are gone.
Written by ansgar
1 year ago
4940 posts since Fri, 07 Apr 06
Very strange. Where do you think did they appear from?
 

Please login to leave a reply, or register at first.