Errors

mysqld Table is marked as crashed and should be repaired

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

or

# 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.]

 

Related Articles