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
Show us what our next emoticon should look like. Join the fun.