Re: big table corruption

[Raj Shekhar]

matt_lists wrote:
every few days I get one of these
MySql: Can't open file: 'mrf.MYI' (errno: 145)
For more information, see Help and Support Center at 
http://www.mysql.com.
Checking table:   './db/mrf'
For more information, see Help and Support Center at 
http://www.mysql.com.
Recovering table: './db/mrf'
For more information, see Help and Support Center at 
http://www.mysql.com.
always recovers fine I guess, nothing gets wrote to the .err file


3 more of the same table crashing last night

Have a look at your /var/log/messages for messages around the time the 
table crashes .  It really should not crash this much.  Is there a quota 
system on your box ? I once had a table marked corrupt and though I 
tried hard to find where the problem is, I was not able to.  Eventually, 
it turned out that the user had exceeded the quota set for her.

--
Raj Shekhar,
System Administrator
Media Web India
http://www.netphotograph.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]