Hy! i have some trouples to compress one table (http://www.notz.ro/table.tar.gz) with myisamcheck. myisampack always terminate with a segementation fault. here an example: istanbul:/var/mysql/sms_plus # /usr/local/mysql/bin/myisampack -vf message_archiv_200005 Compressing message_archiv_200005.MYD: (2135 records) - Calculating statistics normal: 5 empty-space: 0 empty-zero: 0 empty-fill: 4 pre-space: 0 end-space: 1 intervall-fields: 0 zero: 1 Original trees: 10 After join: 8 - Compressing file Segmentation fault if i change the column "part_of_message" from MEDIUMTEXT to CHAR, all works fine. so there still must be a problem in compressing of TEXT columns. i have tried to compress the table on version 3.23.27, 3.23.29 and 3.23.31 (the latest). but the segmentation fault occurs on every version. pherhaps this is an known problem, but already searched on the web, and only find one time the same problem, but this was in 1999 and on version 3.23.20. I hope anyone has an idea, how i can use the column type "TEXT" on my compressed table, because realy need it in future. Thanks, Gernot Pansy ..................................Gernot Pansy, Research & Development .....................................SMS Internet-Dienstleistungs GmbH ...........................................Sporgasse 25/2, A-8010 Graz .................................Tel.: +43 316 813380 DW 34, Fax: - 50 .....................................http://www.sms.at - [EMAIL PROTECTED] --------------------------------------------------------------------- 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
