Hi, When running myisamchk -r -e /path/to/table/table_name.MYD : I get this message back : table_name doesn't have a correct index definition. You need to recreate it before you can do a repair. So I did: step1 drop index index_name1 ON table_name drop index index_name2 ON tabel_name step2 create index index_name1 ON table_name (col_name) create index index_name2 ON table_name (col_name) step3 flush tables; I than reran the myisamchk : same error message again; Can anybody give me some advice on this? I would like to compress the tables but that doesn't work as long as the tables are not repaired. Thanks in advance Filip ------------------------------------------------------- --------------------------------------------------------------------- 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