mysqldump - is marked as crashed and should be repaired

[robertkwild]

hi all,

getting this error when trying to backup the fog database

mysqldump: Couldn’t execute ‘show create table moduleStatusByHost’: Table ‘./fog/moduleStatusByHost’ is marked as crashed and should be repaired (145)

this is the command im running in the script

mysqldump -u root -p’password’ --allow-keywords -x fog > /images/backup/fogall/fogbackup.sql

thanks,
rob

[robertkwild]

can i install php my admin on the fog server or will that mess it up?

[Sebastian Roth]

@robertkwild Search the forums or even the web for the “marked as crashed” error for some good help on this.

You should be able to install phpmyadmin without breaking anything.

[robertkwild]

nice one thanks @Sebastian-Roth

mysqlcheck -c fog moduleStatusByHost -u root -p
Enter password:
fog.moduleStatusByHost OK
[root@lon-c-fog10 backup]# ls
17072021.tar 18072021.tar
[root@lon-c-fog10 backup]# /script/backup.sh
[root@lon-c-fog10 backup]#

[robertkwild]

https://www.stellarinfo.com/article/repair-mysql-database-table.php