myisamchk: error: 140 when opening MyISAM-table

Question

i have this error when run repair?

myisamchk: error: 140 when opening MyISAM-table '/var/lib/mysql/zibarsho_karno/wp_yoast_seo_links.MYI'

how i can fix this ???

Answer 1

ls *.MYI | sed 's/\.[^.]*$//' | xargs myisamchk -F -U

Saved me here because of basename extra operand and other issue. Please note -F -U are for Fast and UPDATE STATUS flag. You can use without it.

Answer 2

This is a bug already reported since MySQL 5.6

Still happening in 8.0.11 so in the mean time you can use the walkarround solution.

Not using the MYI extension.

myisamchk  --force --update-state var/lib/mysql/zibarsho_karno/wp_yoast_seo_links