Script for checking and repairing MySQL databases & tables, including corrupted InnoDB tables

mysql_check.sh

#!/bin/bash

# set mysql into innodb recovery mode on startup
mode=1; sed -i "/^\[mysqld\]/{N;s/$/\ninnodb_force_recovery=$mode/}" /etc/my.cnf

# restart mysql
systemctl restart mysqld

# remove recovery mode setting
sed -i '/innodb_force_recovery/d' /etc/my.cnf

# restart mysql into normal mode
systemctl restart mysqld

# check and auto repair databases
mysqlcheck --all-databases --auto-repair