Ghost Tables

[OldManRiver]

All,

I have a MySQL containing 12 databases, one which has 3 tables. I’ve looked in the docs to determine how to re-index and run maintenance on my databases and it leaves me cold.

Anyway I login at the console and:

show databases; ==>> DB showsuse <>; ==>> DB selectsshow tables; ==>> Tables showselect * from <>; ==>> No such tabledrop table <>; ==>> Table does not existdrop database <>; ==>> DB not empty drop tables tbl1, tbl2, tbl3

Need to run maintenance on the DB that either restores the DBs and Tables or purges the DB so I can rebuild my DB as several apps work from this table.

Thanks!

OMR

[OldManRiver]

All,

It was suggested by contributors to other brds, that I try to fix my problem with the customary “MySQL” Toolset. I downloaded and implemented the toolset, but still had same results.

Also posted this at:

http://forums.mysql.com/read.php?34,191303,191723#msg-191723
http://forums.devshed.com/mysql-help-4/ghost-tables-501171.h tml
http://www.weberforums.com/sutra32362.html#32362
http://www.tek-tips.com/viewthread.cfm?qid=1441061&page= 1
http://www.nabble.com/Ghost-Tables-to14780887.html
http://forums.tizag.com/showthread.php?t=5784
http://www.sitepoint.com/forums/showthread.php?t=525160
http://www.devlib.org/forums/ghost-tables-t6779.html

I’ve made several contribution/replies to some of these; and based on the responses, and in some cases the lack thereof, I think I found a legitimate bug in MySQL.

I uploaded the mysql console screenshot at:

http://www.sitepoint.com/forums/showthread.php?t=525160

Hope all this helps. I’m looking into “how to post a bug” for MySQL as I think that is my next step.

Thanks!

OMR