Waynn: What user are you using to execute mysql from the command line? Perhaps run mysql (from command line) as root then execute the desired actions (such as drop). This will make sure you can drop the table and avoid any further problems.
Sincerely, Craig Huffstetler On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue <[EMAIL PROTECTED]> wrote: > 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] > >
