How to check and repair the database in Messaging Gateway
Last Updated January 17, 2018
How to run a MySQL check on a Messaging Gateway (SMG)
A scheduled database check and optimization is run by Messaging Gateway automatically but can also be run manually from the admin command line interface.
Running a database check and repair on the database allows for ensuring the database is working at its best. The --repair option allows the appliance to attempt to repair errors and some broken links within the database. The --optimize command allows the appliance to clean up white space and disjointed items in the database.
To run the database check or repair
Login to the command line interface (CLI) on the Control Center as the "admin" account.
Enter the command cc-config database --check
When prompted, enter yes to proceed
Once the database check has completed, if one or more tales are marked as "crashed" please run cc-config database --repair command to repair the crashed tables.
Please see HOWTO126381 for more information on the cc-config command.
Imported Document ID: TECH131027
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe