RE: TRUNCATE causes corrupted tables

[Steven Roussey]

Hi!

No, I can't repeat it on command, sorry.

However, I can give a little more info. When inserting, the index file got
bigger. It was the data file that was set to 0 bytes, but did not get bigger
on inserts. Doing a repair fixed it.

I have some tables truncated via scripts, so I turned on mysql's auto repair
feature so it can deal with it rather than me.

Sincerely,

Steven Roussey
Network54.com
http://network54.com/?pp=e