I am using MySql 5.0.21-community Edition for widows XP. I can successfully connect to the MySql Server as a root and create a database 'a'. Which creates a directory 'a' under my mysql\data directory with a single file 'db.opt'. Now dropping the database 'a' gives the following error
ERROR 1010 (HY000): Error dropping database (can't rmdir '.\a', errno: 41) The directory mysql\data\a does not have any other files or hidden files. The commands I have executed are: ------------ Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 5.0.21-community-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database a; Query OK, 1 row affected (0.09 sec) mysql> drop database a; ERROR 1010 (HY000): Error dropping database (can't rmdir '.\a', errno: 41) mysql> --------- I have searched web, lists, bugs and could not find any. Please help. Thank you, Zee __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com