wood@localhost:/var/lib/mysql/mysql$ sudo myisamchk *.MY*
myisamchk: error: 'columns_priv.MYD' is not a MyISAM-table
---------
Checking MyISAM file: columns_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'db.MYD' is not a MyISAM-table
---------
Checking MyISAM file: db.MYI
Data records: 12 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'func.MYD' is not a MyISAM-table
---------
Checking MyISAM file: func.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'help_category.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_category.MYI
Data records: 36 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'help_keyword.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_keyword.MYI
Data records: 385 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'help_relation.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_relation.MYI
Data records: 745 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'help_topic.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_topic.MYI
Data records: 466 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
---------
myisamchk: error: 'host.MYD' is not a MyISAM-table
---------
myisamchk: error: 'host.MYI' is not a MyISAM-table
---------
myisamchk: error: 'proc.MYD' is not a MyISAM-table
---------
Checking MyISAM file: proc.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
---------
myisamchk: error: 'procs_priv.MYD' is not a MyISAM-table
---------
Checking MyISAM file: procs_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'tables_priv.MYD' is not a MyISAM-table
---------
Checking MyISAM file: tables_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'time_zone_leap_second.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_leap_second.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone_name.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_name.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone_transition.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_transition.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone_transition_type.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_transition_type.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'user.MYD' is not a MyISAM-table
---------
Checking MyISAM file: user.MYI
Data records: 12 Deleted blocks: 0
- check file-size
myisamchk: error: Size of indexfile is: 2048 Should be: 4096
myisamchk: error: Size of datafile is: 836 Should be: 5256
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
myisamchk: Unknown error 126
myisamchk: error: Can't read indexpage from filepos: 1024
MyISAM-table 'user.MYI' is corrupted
Fix it using switch "-r" or "-o"
wood@localhost:/var/lib/mysql/mysql$ sudo myisamchk -r user.MYI
- recovering (with sort) MyISAM-table 'user.MYI'
Data records: 12
- Fixing index 1
- Fixing index 2
Data records: 1
wood@localhost:/var/lib/mysql/mysql$
wood@localhost:/var/lib/mysql/mysql$ sudo myisamchk *.MY*
myisamchk: error: 'columns_priv.MYD' is not a MyISAM-table
---------
Checking MyISAM file: columns_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'db.MYD' is not a MyISAM-table
---------
Checking MyISAM file: db.MYI
Data records: 12 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'func.MYD' is not a MyISAM-table
---------
Checking MyISAM file: func.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'help_category.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_category.MYI
Data records: 36 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'help_keyword.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_keyword.MYI
Data records: 385 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'help_relation.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_relation.MYI
Data records: 745 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'help_topic.MYD' is not a MyISAM-table
---------
Checking MyISAM file: help_topic.MYI
Data records: 466 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check record links
---------
myisamchk: error: 'host.MYD' is not a MyISAM-table
---------
myisamchk: error: 'host.MYI' is not a MyISAM-table
---------
myisamchk: error: 'proc.MYD' is not a MyISAM-table
---------
Checking MyISAM file: proc.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check record links
---------
myisamchk: error: 'procs_priv.MYD' is not a MyISAM-table
---------
Checking MyISAM file: procs_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'tables_priv.MYD' is not a MyISAM-table
---------
Checking MyISAM file: tables_priv.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
---------
myisamchk: error: 'time_zone_leap_second.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_leap_second.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone_name.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_name.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone_transition.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_transition.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'time_zone_transition_type.MYD' is not a MyISAM-table
---------
Checking MyISAM file: time_zone_transition_type.MYI
Data records: 0 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
---------
myisamchk: error: 'user.MYD' is not a MyISAM-table
---------
Checking MyISAM file: user.MYI
Data records: 1 Deleted blocks: 0
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
wood@localhost:/var/lib/mysql/mysql$