l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
April 21: Google Glass
Next Installfest:
TBD
Latest News:
Mar. 18: Google Glass at LUGOD's April meeting
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.

-Gabe
_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
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:
Appahost Applications
For a significant contribution towards our projector, and a generous donation to allow us to continue meeting at the Davis Library.