Re: How to purposely corrupt a table

2010-01-13 Thread Carlos Williams
On Wed, Jan 13, 2010 at 1:14 PM, Jim Lyons wrote: > I have a script that does this.  It goes through every table in every > database (excluding specific database like information_schema, etc) and > issues the command: > > select 1 from . limit 1; Interesting. Would you mind sharing the script? Is

Re: How to purposely corrupt a table

2010-01-13 Thread Jim Lyons
I have a script that does this. It goes through every table in every database (excluding specific database like information_schema, etc) and issues the command: select 1 from . limit 1; At first, I only checked for the error code for a crashed table, but found I had some other tables that had pr

How to purposely corrupt a table

2010-01-13 Thread Matt Carlson
Hello, This is going to be a very odd question. I'm looking for a way to purposefully corrupt a table. The reason behind this, is that I would like to write a php script that will go through all databases/tables in the environment, and find any tables that are marked as crashed/corrupt, so that