Try putting the data directory on a small partition and let it get filled 100% with a single update that does not get fully committed due to disk full, then turn the power off to the computer so there is no attempt for a nice shutdown. You should also get a corruption in the master binary logs, if binary logging is turned on.
If you use VMWare (vmware server is free) to virtualize a test OS with small drives, it will be easier to do this. -RG Richard Edward Horner wrote: > Hi, > > I'm working on a program that will run in the event that tables are > crashed or corrupt. Can anyone recommend a good method for crashing my > tables or corrupting them so I have some test cases? I'm mostly > interested in MyISAM and InnoDB table types. > > I was thinking I would just start an infinite loop with an UPDATE > statement in it and then kill -9 the mysqld process. > > Any better ideas? > > Thanks, Rich(ard) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]