Waynn- does the OS user you use to execute mysql have create/write/read/execute rights to the ./test folder?
Martin- ----- Original Message ----- From: "Waynn Lue" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Saturday, March 08, 2008 6:58 AM 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
