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. error during backup - "can't open" table .MYI

    error during backup - "can't open" table .MYI

    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: 3

    Description:
    We got the following error during backup:

    /exlibris/sfx_ver/sfx_version_3/app/perl/bin/perl /exlibris/sfx_ver/sfx_version_
    3/app/mysql/bin/mysqlhotcopy --user=root --password=xxxxxx--socket=/exlibris
    /sfx_ver/sfx_version_3/app/mysql/socket/mysql.sock sfxlcl3 /exlibris/sfx_ver/sfx
    _version_3/tmp/dumpdir
    DBD::mysql::db do failed: Can't open file: 'STAT_TARGET_SERVICE.MYI' (errno: 145
    ) at /exlibris/sfx_ver/sfx_version_3/app/mysql/bin/mysqlhotcopy line 468.
    ERROR when: /exlibris/sfx_ver/sfx_version_3/app/perl/bin/perl /exlibris/sfx_ver/
    sfx_version_3/app/mysql/bin/mysqlhotcopy --user=root --password=xxxxxx--sock
    et=/exlibris/sfx_ver/sfx_version_3/app/mysql/socket/mysql.sock sfxlcl3 /exlibris
    /sfx_ver/sfx_version_3/tmp/dumpdir

    Resolution:
    This error indicates that a table index is corrupt in the database of an instance you are trying to back up.
    This problem can be fixed in the following manner:

    Log in as the sfxlcl3 user (or user of the instance during the backup of which the error occured).
    Use the 'da' shortcut to go to the admin directory.
    Run the server_admin_util program.
    Choose option 4 (Database maintenance), then option 3 (REPAIR MySQL tables).
    You will be asked to enter the name of the table to repair. Enter STAT_TARGET_SERVICE (or another table, depending on the table name in the error message).

    Afterwards you might want to use option 2 (CHECK MySQL tables) to verify that the table has been completely repaired.

    Additional Information

    error,backup,table,corrupt,repair,MYI,server_admin_util


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • error at the rev-up logs
      • Error in RSI Log When Running RSI Index Build
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 3
      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