I'll tell a much easier way to corrupt table. Open the data or index file,
remove some text data in the file and save.
It will show it a corrupt. ( Only for test setups ).
On Tue, Oct 19, 2010 at 10:11 PM, Hank wrote:
> It's easy to corrupt the MYISAM index (MYI) file... I do something
> like th
It's easy to corrupt the MYISAM index (MYI) file... I do something
like this in linux -- assuming your table is not tiny, and mysql isn't
running or you have a lock on the table:
dd if=table.MYI of=table2.MYI bs=2048 count=100
then copy table2.MYI over table.MYI and then "flush tables" and then u
Hi,
Keep key_buffer_size very low and insert lots of data into table (myisam).
After some time the index file will crash.
Krishna
CGI.COM
On Tue, Oct 19, 2010 at 7:53 PM, Steve Staples wrote:
> Ok, been googling all morning, and keep getting the same post (on
> multiple different sites).
>
>
Ok, been googling all morning, and keep getting the same post (on
multiple different sites).
Is there a way, where i corrupt a table purposely? I've tried playing
with the .MYD file, and yeah, it "marks" it deleted under the check
routine, but the table is still readable/writable, just doesn't
