Strange MySQL problem

[JTE]

A couple of days ago I tried to drop an old, unused database from MySQL. Apparantly something went wrong - the database still exists, it shows a couple of tables in it, but there is no way of accessing them whatsoever. DirectAdmin still shows the database, but for some reason it manages to count -1 users on it.

I've tried to go into the MySQL client by SSH, and trying to repair the tables. I can access the database (use database; ) but a repair statement fails with the message that apparantly some file for that database was lost (a file with the same name as the table). My guess is that MySQL deleted the files but somehow failed to delete the database itself. The database user was deleted properly.

Even though it only affects this single database, I'd like to get it sorted out. Any suggestions?

(btw, I am the server's admin)

 

[nobaloney]

is there a directory of the database name in /var/lib/mysql?

If so, and if everything else has been deleted you can just delete the database:

rm -Rf /var/lib/mysql/databasename

Jeff

 

[JTE]

Seems to have fixed the problem, thanks!