Hi, What kind of storage engine you are using? Did u try to remove the database directory from the file system? Could you paste the output you get when you are trying to drop tables and database.
Check in the database directory for .frm file. If you found them without data and index files. Try to remove them before dropping the database. Saravanan --- On Mon, 1/14/08, OldManRiver <[EMAIL PROTECTED]> wrote: > From: OldManRiver <[EMAIL PROTECTED]> > Subject: Re: Ghost Tables > To: mysql@lists.mysql.com > Date: Monday, January 14, 2008, 11:23 PM > 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.html > http://www.weberforums.com/sutra32362.html#32362 > http://www.tek-tips.com/viewthread.cfm?qid=1441061&page=1 > http://forum.mysqlperformanceblog.com/s/t/575/ > 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 case 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 > -- > View this message in context: > http://www.nabble.com/Ghost-Tables-tp14780887p14805914.html > Sent from the MySQL - General mailing list archive at > Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
