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$