On Fri, 25 Jan 2002, Sinisa Milivojevic wrote: Hi, sorry, I didn't get it. As far as I know there's no way yet how to uncompress table my using SQL command. I have to uncompress using `myisamchk --unpack *.MYI`, right?
> =?iso-8859-2?Q?Martin_MOKREJ=A9?= writes: > > Hi, > > when I'm trying to lock multiple tables and some of the are Compressed, > > mysql warn's me only about the first-one being Compressed. It either > > reports the first Compressed table only from the list, or it checks > > only the first-one in the list of tables to be locked: > > > > mysql> use Escherichia_coli_O157_H7_EDL933 > > Database changed > > mysql> lock table blast_data write; write, blimps_data write, cogs_data write, >coils_data write, contig_data write, funcat_data write, intragenome_data write, >known3d_data write, nonglob_data write, orf_data write, pfam_data write, prd_data >write, pros_data write, prot_data write, scop1_data write, scop2_data write, seg_data >write, tmhmm_data write; > > ERROR 1036: Table 'blast_data' is read only > > mysql> > > > > `myisamchk -f -d ' reports on those tables their status, and most of them were >Compressed. > > I don't think it make's sense to paste the output here. > > > > I don't know if it's really `ERROR', because I'm locking the tables > > to FLUSH TABLES and then in the backgroung run `myisamchk --unpack *.MYI'. > > ;)[B > > > > Linux 2.4.17, > > /usr/local/mysql/bin/mysqld Ver 3.23.42 for pc-linux-gnu on i686 > > -- > > Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs > > MIPS / Institute for Bioinformatics <http://mips.gsf.de> > > GSF - National Research Center for Environment and Health > > Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany > > tel.: +49-89-3187 3616 , fax: +49-89-3187 3585 > > > > Please do not run myisamchk while the server is running. > > Use CHECK TABLE to check tables ... > > -- > Regards, > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> > / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer > /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus > <___/ www.mysql.com > -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics <http://mips.gsf.de> GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax: +49-89-3187 3585 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
