table keeps corrupting

[peterb1985]

I have a MyISAM table that receives a stock update every hour from a text file. Every hour i delete the data from the table and load up the new text file. Every few days the table becomes corrupt with the following message:

warning Table is marked as crashed and last repair failed
warning Size of indexfile is: 716800 Should be: 479232
warning Size of datafile is: 910728 Should be: 910668
error Can't read indexpage from filepos: -1
error Corrupt

Does anyone know why this is happening?

Should i not load the data the way i have said?

Thank You for any replies.

 

[ericbrunson]

I would suspect a hardware problem. Bad memory or bad disk sector, maybe.