l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Apr 21 23:32

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] mysql oops
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [vox-tech] mysql oops

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.

vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
EDGE Tech Corp.
For donating some give-aways for our meetings.