Windows 2K MySQL V ? (recent). Sorry, I'm not at my own machine at present,
can't check actual version number.
Installed, running and everything is ok, except I created a database called
'xyz' as a test then decided to delete it.
I used the command: DROP DATABASE 'xzy'; which returns a message that
the command executed successfully, affecting however many rows were in the
database at the time.
SHOW DATABASES; shows that the database is still there.
I then re-tried using command: DROP DATABASE if exists 'xyz'; with
the same result (no error messages).
I then tried using mysqladmin to do the job, with the same result.
I then used: DELETE
FROM mysql.db
WHERE Db = "xyz";
which also executes successfully.
I test by using: SELECT db
FROM mysql.Db;
which reveals that the database is NOT there. However! SHOW DATABASES; still
shows that the database is there!
I have also tried right click drop database in the GUI MySQL management
window. It fails to remove it.
I have stopped and re-started the service and the computer several times.
DROP DATABASE works fine for other databases I create and remove, just not
this one.
Is this a curly one? Any help appreciated.
Andrew
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
