MySQL table is marked as crashed and last (automatic?) repair failed

1 min read

To repair a crashed table in CentOS + VestaCP server.

Stop the MariaDB service via VestaCP

goto the mysql folder
/var/lib/mysql/DATABASENAME/TABLE_NAME

try to run
myisamchk -r $TABLE_NAME

if it doesn’t work, then run
myisamchk -r -v -f $TABLE_NAME

Start the mariadb again via vestaCP GUI.

Latest from Blog