Purposely Corrupting a table

2010-10-19 Thread Steve Staples
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

Re: Purposely Corrupting a table

2010-10-19 Thread Krishna Chandra Prajapati
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

Re: Purposely Corrupting a table

2010-10-19 Thread Hank
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

Re: Purposely Corrupting a table

2010-10-19 Thread Suresh Kuna
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