Re: Corruptions like crazy
In preparation for the last test "SELECT COUNT(*) FROM tblComposerFile;" I did this.
Here you can see I have fixed all errros on the file and checked they are not showing any more.
bash-3.2# myisamchk /var/lib/mysql/musiciansjamnetwork/*.MYI >> /tmp/MyIsamErrors
bash-3.2# myisamchk /var/lib/mysql/musiciansjamnetwork/*.MYI >> /tmp/MyIsamErrors
I just added one record to each of the three files using my website page and these are the messages I get after I run the check again.
bash-3.2# myisamchk /var/lib/mysql/musiciansjamnetwork/*.MYI >> /tmp/MyIsamErrors
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of indexfile is: 34816 Should be: 35840
myisamchk: error: Size of datafile is: 14308 Should be: 14724
myisamchk: error: Found key at page 10240 that points to record outside datafile
myisamchk: error: Record-count is not ok; is 397 Should be: 398
myisamchk: warning: Found 397 key parts. Should be: 422
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/tblComposerFile.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of indexfile is: 49152 Should be: 50176
myisamchk: error: Size of datafile is: 25212 Should be: 25644
myisamchk: error: Found 101 keys of 723
myisamchk: error: Record-count is not ok; is 722 Should be: 723
myisamchk: warning: Found 722 key parts. Should be: 748
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/tblSongNamesFile.MYI' is corrupted
Fix it using switch "-r" or "-o"
myisamchk: warning: 1 client is using or hasn't closed the table properly
myisamchk: error: Size of indexfile is: 45056 Should be: 46080
myisamchk: error: Size of datafile is: 42714 Should be: 42756
myisamchk: error: Found 101 keys of 1018
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/tblSongsMaster.MYI' is corrupted
Fix it using switch "-r" or "-o"
================================================================
Here is the test.
mysql> select count(*) from tblComposerFile
-> ;
+----------+
| count(*) |
+----------+
| 398 |
+----------+
1 row in set (0.00 sec)
Subject
Written By
Posted
Re: Corruptions like crazy
April 30, 2015 08:44AM
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.