Corrupted MySQL Database

[Anon]

Hi

It has happened twice now, my table in MySQL has become corrupt. Both times it was repaired by the simple "REPAIR TABLE ldbcx" query, however, i can't put this php script into heavy use until i figure out why the table keeps getting corrupt. Any specific reasons this could happen? Should I just schedule a cron job like once an hour to run a <?php mysql_connect(); mysql_query("REPAIR TABLE ldbcx"); ?> script?

AAggh.

Thanks.

[[deleted]]

"Should I just schedule a cron job like once an hour to run a <?php mysql_connect(); mysql_query("REPAIR TABLE ldbcx"); ?> script? "

ofcourse not :-)

You have to find out what's corrupting the tables.
Think of things like low memory, low diskspace (do you have enough temp and swap space, instable MYSQL versions, other processes that interfere with MySQL's disk operations (what kind of disks is MYSQL using to do it's thing?)

[Anon]

On my old server, I often had corrupt table. I switch server and it never happen since and its been about 4 month ago. Someone told me it was because my old server had cheap/defect memory. Try changing your ram, it work for me.