In certain situations we may be required to run 'mysqlcheck' to perform an integrity check on all databases and tables to look for issues like corrupted indexes or data. If issues get detected, we will also need to run the repair.
The entire "procedure" requires only two commands and a bit of patience:
# The '-c' flag is for running the check: /opt/pbxware/sh/mysqlcheck -c --all-databases # The '-r' flag is for running the repair: /opt/pbxware/sh/mysqlcheck -r --all-databases
This can be ran without stopping the services.