mysql won't drop database

[pedalpete]

I think I somehow REALLY screwed up my database. I get no return making queries, REPAIR said it was all ok, I mysqldump was hanging, etc. etc, lots of nasty stuff.

So, I decided to drop the database and rebuild it from my back-up.
but even the drop is hanging with the command

Drop Database zifi

I was searching for a more powerful way to get rid of it, but can't find anything.

Any ideas?

[realin]

I think I somehow REALLY screwed up my database. I get no return making queries, REPAIR said it was all ok, I mysqldump was hanging, etc. etc, lots of nasty stuff.

So, I decided to drop the database and rebuild it from my back-up.
but even the drop is hanging with the command

Drop Database zifi

I was searching for a more powerful way to get rid of it, but can't find anything.

Any ideas?

try a third party tool..
Phpmyadmin, MySQL query browser, SQL Yog

And check for the user having appropriate privileges before dropping schema ..

hope this helps :)
Cheers !!

[pedalpete]

i think the tools you mention are just graphical interfaces for mysql, so they are essentially entering the commands for me, but abstracting it.

I am the root user, so have full control.

Also, i'm on a linux server.

[pedalpete]

I left the server sitting with "drop database" overnight, and it eventually returned "database does not exist", and now I can't connect to it, so I guess that somehow solved the issue, but didn't really help with why.

[mwasif]

Go to mysql data directory and see if that database exists or not.

[pedalpete]

thanks mwasif,

I'll do that if I run into this again, it seems mysql thought it didn't exist, but it actually did.

Now I know how to check it next time, but what do I do if the database didn't exist?
Mysql let me connect to it using "USE database", so I assume I can't just do another 'create' call.