Hello folks,
I use myisampack to pack old MyISAM tables to archive good amount of data. In order to save more space, I decided to get rid of index files and to reconstruct those indexes whenever needed. I've rebuild indexes on plain MyISAM tables with no problem. I use: repair table TABLENAME USE_FRM; from MySQL console to rebuild index files from scratch. When I try the same on packed MyISAM tables MySQL fails. It gives me bunch of same type of errors :
| test.z_976287758_978107517 | repair | info | Found block that points outside data file at 382300672 |
And then it actually deletes actual data file (.MYD) :
-rw-r----- 1 0 Mar 20 21:58 z_976287758_978107517.MYD
-rw-rw---- 1 1.0K Mar 20 21:59 z_976287758_978107517.MYI
-rw-r----- 1 8.7K Mar 20 20:15 z_976287758_978107517.frm
Please help me, how to fix this issue?
Thanks.
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --