Re: Corruptions like crazy

[John Bowles]

I tried two things. First I removed these lines from the my.cng but no success.


log-bin=/tmp/mysql-bin #jwb: I inserted this line
binlog-do-db=MyDatabaseName #jwb: I inserted this line

Next I did this: I stopped mysql, I ran the fixes, I check the errors, I started mysql, I did my web updates (three inserts), I stopped mysql, then I ran the error checks.

The above did not fix the problem. One thing has changed. These errors no longer appear before the worse errors start. It now jumps immediately to the worse errors that I reported in the first post. So maybe the disk is the problem.

myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/MyTable1.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/MyTable2.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/MyTable3.MYI' is usable but should be fixed