Gartside, Friday, May 10, 2002, 3:45:07 AM, you wrote: G> Windows 2K MySQL V ? (recent). Sorry, I'm not at my own machine at present, G> can't check actual version number.
G> Installed, running and everything is ok, except I created a database called G> 'xyz' as a test then decided to delete it. G> I used the command: DROP DATABASE 'xzy'; which returns a message that G> the command executed successfully, affecting however many rows were in the G> database at the time. G> SHOW DATABASES; shows that the database is still there. G> I then re-tried using command: DROP DATABASE if exists 'xyz'; with G> the same result (no error messages). Please, check you database directory if there are any other files than MySQL table files (*.MYD. *.MYI, .frm etc.). MySQL doesn't remove database if there are any non-MySQL files in the dir. G> I then tried using mysqladmin to do the job, with the same result. G> I then used: DELETE G> FROM mysql.db G> WHERE Db = "xyz"; G> which also executes successfully. :) You removed _users_ with _privileges_ on 'xyz' database, it's not related with database removal. G> I test by using: SELECT db G> FROM mysql.Db; G> which reveals that the database is NOT there. Sure, you removed all matched rows from table 'db' :) G> However! SHOW DATABASES; still G> shows that the database is there! G> I have also tried right click drop database in the GUI MySQL management G> window. It fails to remove it. G> I have stopped and re-started the service and the computer several times. G> DROP DATABASE works fine for other databases I create and remove, just not G> this one. Please, check your database directory! You have posted your letter 3 times and Heikki already asked you to check the dir. G> Is this a curly one? Any help appreciated. G> Andrew -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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