Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: OldManRiver (davisoftmegsinet.net)
Date: Sat Jan 12 2008 - 18:48:38 CST
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 shows
use <<dbname>>; ==>> DB selects
show tables; ==>> Tables show
select * from <<tbl>>; ==>> No such table
drop table <<tbl>>; ==>> Table does not exist
drop database <<dbname>>; ==>> 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.
View this message in context: http://www.nabble.com/Ghost-Tables-tp14780887p14780887.html
Sent from the MySQL - General mailing list archive at Nabble.com.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql