Watch4Net APG: How can I check and automatically repair MySQL database tables?

Products

• VMware

Issue/Introduction

Watch4Net: How can I check and automatically repair MySQL database tables?

Environment

VMware Smart Assurance - Watch4Net/M&R

Resolution

Execute the following command to do this:

/opt/APG/Databases/MySQL/Default/bin/mysqlcheck --check --extend --auto --repair --use-frm --quick --check-only-changed --verbose --host=127.0.0.1 --port=53306 -p --user=root <database>

Password is watch4net

Example
To check and automatically repair all tables in the 'apg' database:

/opt/APG/Databases/MySQL/Default/bin/mysqlcheck --check --extend --auto --repair --use-frm --quick --check-only-changed --verbose --host=127.0.0.1 --port=53306 -p --user=root apg