Sample Header Ad - 728x90

Repair MyISAM table

1 vote
1 answer
66 views
I'm trying to recover a corrupted MyISAM table because a sudden power loss. The problem is that this table is very heavy size around 100GB with 2M rows. I have tried with the command myisamchk -rvf table it throws me some errors “Wrong bytesec” but it keeps running it gets to the point where I get error “Errcode: 28 ” and when I check the table .TMD it size around 1.5TB eating all my free space. My questions are. 1. How can I repair the table 2. How is it possible the repair of this table weighs so much, I think even if I put a 4TB disk it will always fill it. What are my other options of recovering the table?
Asked by Kurogane (11 rep)
Feb 13, 2025, 07:11 AM
Last activity: Feb 13, 2025, 07:58 AM