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 --------------------------------------------------------------------- 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
