Can't drop database that shows up in show databases
- Date: Sat, 8 Mar 2008 03:58:34 -0800
- From: "Waynn Lue" <waynnlue@xxxxxxxxx>
- Subject: Can't drop database that shows up in show databases
SHOW DATABASES; shows that I have a database called "test", but when I
call "DROP DATABASE test", I get
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
When I run any queries on that database, I get errors like:
mysql> select * from Users;
ERROR 1017 (HY000): Can't find file: './test/Users.frm' (errno: 13)
My previous solution of deleting the ./test folder worked only
temporarily, but restarting mysqld seemed to recreate it. Anyone have
ideas on how to drop this database?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx