Re: Can't drop database that shows up in show databases

["Baron Schwartz" <baron@xxxxxxxxx>]

Hi,

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

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx