This problem actually started after I moved the datadir to another folder, so that's quite possible. We stopped everything, rsynced the folders over, then restarted mysql. But I do notice a permissions problem, since the owner currently is root. I'll chown it to mysql then see what happens.
I'll post back with results. Thanks for all the advice, Waynn On 3/8/08, Baron Schwartz <[EMAIL PROTECTED]> wrote: > Hi, > > 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) > > Whenever you see "errno: X", run perror and see what the error is: > > [EMAIL PROTECTED]:~$ perror 13 > OS error code 13: Permission denied > > That is why other posters are suggesting it might be a permissions > problem. It sounds to me like there might be an InnoDB problem mixed > in with this: did you delete any .frm files (or databases) from the > filesystem without first dropping the InnoDB files that use them? > InnoDB will complain about this if you did. > > > > > 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]
