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 <heskin@stripped> wrote:
> 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
> Your table will be unreadable until you rebuild the index with REPAIR
> TABLE or myisamchk. The MYD file will remain intact.
> If your MYI file is smaller than 200k, then just reduce the count=#.
> > On Tue, Oct 19, 2010 at 7:53 PM, Steve Staples <sstaples@stripped>
> >> 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 have
> >> any info when selecting it...
> >> is there another way to corrupt the table, where you can't even select
> >> from it, or the responce back from a select is an error?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: