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
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:
[URL=“MySQL :: Re: Ghost Tables”] MySQL :: Re: Ghost Tables
http://forums.devshed.com/mysql-help-4/ghost-tables-501171.h tml
[URL]http://www.weberforums.com/sutra32362.html#32362[/URL]
http://www.tek-tips.com/viewthread.cfm?qid=1441061&page= 1
[URL]http://www.nabble.com/Ghost-Tables-to14780887.html[/URL]
[URL]Tizag Tutorials
[URL]http://www.sitepoint.com/forums/showthread.php?t=525160[/URL]
[URL]http://www.devlib.org/forums/ghost-tables-t6779.html[/URL]
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:
[URL]http://www.sitepoint.com/forums/showthread.php?t=525160[/URL]
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