List:Cluster« Previous MessageNext Message »
From:Jim Hoadley Date:April 7 2005 2:45am
Subject:Re: deleteing phantom table #sql-4fc_ffd
View as plain text  
Look in MySQL's data directory. There'll be a header (.frm) file with the same
name. Delete it.

-- Jim Hoadley
   Sr Software Eng
   Dealer Fusion, Inc



--- Ted Schundler <tschundler@stripped> wrote:
> Oops. The error for drop table is "#1051 - Unknown table '#sql-4fc_ffd'"
> The "can't open..." error is when trying to see what is in the table
> (i.e. select * from)
> 
> On Apr 6, 2005 2:40 PM, Ted Schundler <tschundler@stripped> wrote:
> > Somehow a strange table got into my DB, I'm guessing something
> > temporary that didn't get cleaned up. However I can't delete it.
> > 
> > "DROP TABLE `#sql-4fc_ffd`" via SQL doesn't work. ("#1016 - Can't open
> > file: '#sql-4fc_ffd.ndb' (errno: 1)") and ndb_drop_table via command
> > line doesn't work either ("709: No such table existed") However,
> > ndb_show_tables does list that table in its output, so it's
> > deffinately an ndb thing.
> > 
> > Any ideas?
> > 
> > 
> > Ted
> >
> 
> -- 
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe:    http://lists.mysql.com/cluster?unsub=1
> 
> 


		
__________________________________ 
Yahoo! Messenger 
Show us what our next emoticon should look like. Join the fun. 
http://www.advision.webevents.yahoo.com/emoticontest
Thread
deleteing phantom table #sql-4fc_ffdTed Schundler6 Apr
  • Re: deleteing phantom table #sql-4fc_ffdTed Schundler6 Apr
Re: deleteing phantom table #sql-4fc_ffdJim Hoadley7 Apr
  • Re: deleteing phantom table #sql-4fc_ffdpekka7 Apr