Hi, I have a table: CREATE TABLE WI_PICTUREFILES ( SECTIONID VARCHAR(50) BINARY NOT NULL, PICTUREID VARCHAR(50) BINARY, PICTUREFILE VARCHAR(200) BINARY NOT NULL, PICFILEXT VARCHAR(5) BINARY NOT NULL, SHEETNO VARCHAR(2) BINARY, UNIQUE PICTUREFILES_XPK (SECTIONID,SHEETNO), INDEX PICTUREFILES_X1 (PICTUREFILE) ); The table has 32314 records. When I compress it with 'myisampack' it's fine but after running 'myisamchk -rq' the table can't be opened. When running 'myisamchk -rq' I get this message: --------------------------------------------------------- E:\standalone\database\dtim9t>myisamchk -rq E:\standalone\database\dtim9t\wi_picturefiles - check key delete-chain - check record delete-chain - recovering (with sort) MyISAM-table 'e:\standalone\database\dtim9t\wi_picturefiles.MYI' Data records: 32314 - Fixing index 1 myisamchk: error: Found too many records; Can`t continue MyISAM-table 'E:\standalone\database\dtim9t\wi_picturefiles' is not fixed because of errors Try fixing it by using the --safe-recover (-o) or the --force (-f) option --------------------------------------------------------- Then I run 'myisamchk --safe-recover' and it works again. Is this a bug in mySQL, or?! Best regards Joacim Järkeborn Consultant - Systems Development Cell Network Sverige AB __________________________________________________ Volvo IT Dept 9224, ARH4 Gothenburg, Sweden Telephone..: +46 31 765 49 65 Mobilephone: +46 708 78 58 01 E-mail.....: [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