[vox-tech] mysql oops

[vox-tech@lists.lugod.org]

On Wed, Apr 21, 2004 at 03:07:01PM -0700, grosa@ucdavis.edu wrote:
> 
> 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?
> 

Well, I guess the cheap way is to 

cd /var/lib/mysql/my_db
rm * -f

move along now, nothing to see here.

-Gabe