Check and Fix Corrupted Tables Via server_admin_util
- Article Type: General
- Product: SFX
- Product Version: 4
Desired Outcome Goal:
Make sure there are no corrupted tables preventing statistical data from being queried and maintained
Procedure:
Check Tables
1. Access the Server using the relevant instance user
2. Access the Server Admin Utility
3. Type ‘4’ for Database maintenance
4. Type ‘2’ for CHECK MySQL tables
5. Press Enter to make sure all tables are checked
6. Type ‘Y’ to continue
It can take a while for all tables to be checked.
The status will display for each table: ‘OK’, ‘Warning’ or ‘Error’ (meaning it is corrupt).
The Warning status can be ignored.
Repair Tables
1. Access the Server using the relevant instance user
2. Access the Server Admin Util
3. Type ‘4’ for Database maintenance
4. Type ‘3’ for REPAIR MySQL tables
5. Type the name of the corrupted table
6. Type ‘Y’ to continue
7. After the repair is done, check the log describing what the issue was and whether the number of rows has been changed (describing the amount of data lost)
Additional Information
SFX System Administration Guide, Chapter 6: Server Admin Utility
- Article last edited: 12/26/2013