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
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
