In this article, we will learn how to solve mysqld Table is marked as crashed and should be repaired error.
First, take a backup of the MySQL data:
Create a backup directory
# mkdir -p ~/mysqlbkp
Dump MySQL databases
# mysqldump –all-databases –routines –triggers > ~/mysqlbkp/dbcopy.sql
Copy MySQL data directory
# cp -r /var/lib/mysql/mysql ~/mysqlbkp/
Next, try to check MySQL Databases with repair command:
# mysqlcheck -r -A
# mysqlcheck -u root –auto-repair –check –all-databases
After this, try to restart MySQL service once again.
If MySQL service still now running, contact us. Our server experts will solve the issue.
[Need assistance to fix this error or install tools? We’ll help you.]