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
>
>

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 <baron@xaprb.com> wrote:
> 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
> >
> >
>