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