Database cannot be deleted -- SQL Error 1049: Unknown database
| User, date | Message |
|---|---|
|
Written by WaveLength
2 months 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
2 months ago 3949 posts since Fri, 07 Apr 06 |
Do these databases show up in a SHOW DATABASES query result? |
|
Written by WaveLength
2 months ago 11 posts since Thu, 07 Jul 11 |
No, they do not appear after a SHOW DATABASES query. |
|
Written by WaveLength
2 months 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
2 months ago 3949 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. |