If you get this error message while backing up mysql database with mysqldump, you can fix it simply using a command.
# myisamchk -r /var/lib/mysql/dbname/tablename.MYI
- recovering (with sort) MyISAM-table '/var/lib/mysql/dbname/tablename.MYI'
Data records: 4301
- Fixing index 1
Found block that points outside data file at 2051036
Found block that points outside data file at 2051040
Here is myisamchk is the utility tool that we need to use and "/var/lib/mysql/dbname/tablename.MYI" is the physical path of the table.
Hope this will help you to solve your problem.

0 comments:
Post a Comment