MySQL - #1051 - Unknown table 'userchat'

Question:

I have a local database that I need to drop and reload a new version in.The drop hanged for a long time, couldn't restart WAMP so I restarted my PC.

Now the database is empty except for one table and it says - #1051 - Unknown table 'userchat'I've tried lots of ways to drop this table with no luck.eg: I tried myphpadmin gui stuff and drop table blah and drop database blah etc.

Is there a trick to removing a database in this situation?I can remove and re-install WAMP if I need to.

thx

Answer:

Use mysqlcheck — A Table Maintenance Program and than again try to drop database:

mysqlcheck --auto-repair --databases gonegr_db --user=your_username --password