[vox-tech] mysql oops

[vox-tech@lists.lugod.org]

Hey all,

I was playing around with mysql and I switched a table to type bdb (berkeley
database), like so (table names changed to protect the innocent):

mysql> ALTER TABLE mytable TYPE=BDB;

and now it shows up when i do

mysql> show tables;

+----------------+
| Tables_in_db   |
+----------------+
| mytable        |
| other_table    |
+----------------+
2 rows in set (0.00 sec)

but I can't delete it:

mysql> DROP TABLE mytable;
ERROR 1051: Unknown table 'mytable'

how do I get rid of this thing?

thanks,
-Gabe