Hi,

On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue <waynnlue@gmail.com> 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:

baron@kanga:~$ 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/mysql?unsub=baron@xaprb.com
>
>