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
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 sstap...@mnsi.net wrote:
Ok, been googling all morning, and keep getting the same post (on
multiple
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
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 hes...@gmail.com wrote:
It's easy to corrupt the MYISAM index (MYI) file... I do