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
