I had a table crash then using myisam I manage to as below. So now I can access my table but I want to learn more what cause it to crashed and how to avoid this in future. Must I change my table type to innodb but that does have problem also right?
Data records: 94434116 Deleted blocks: 0
myisamchk: warning: Table is marked as crashed and last repair failed
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: error: Found 101 keys of 94434116
- check record links
myisamchk: error: Keypointers and record positions doesn't match
MyISAM-table '/var/lib/mysql/fms/tripData_ZS.MYI' is corrupted
Fix it using switch "-r" or "-o"