Re: Corruptions like crazy
Another thing that I think might be important.
Twice I think I have been forced too run a backup then a return with phpMyAdmin because the myisamchk program was saying all errors had been fixed yet my website page run would kick out an error when the PHP ran the MySql command to insert the record. After this live MySql error occurred I would run the myisamchk program again and it would say there were no errors. In this situation I was obviously stuck and had to run the backup and return (or just return the last backup). So this fixed the problem. Then I would do an add to the database with my webpage and I would get errors like below. Now if I choose to not fix these errors with the -r option I could just keep on adding more and more records with my webpage and the errors below would not change. But if I decide to fix the errors below with the "myisamchk -r" run and after that I try to add records with my webpage I would get the full corruption errors for the three files as shown in the prior post.
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
Subject
Written By
Posted
Re: Corruptions like crazy
April 30, 2015 08:59AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.