Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    SFX

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Knowledge Articles
    4. Check and Fix Corrupted Tables Via server_admin_util

    Check and Fix Corrupted Tables Via server_admin_util

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Changing the size of the A-Z List "info" pop-up window
      • Check if an Online2Offline Cron is Scheduled
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 4
      2. contype:kba
      3. Prod:SFX
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved