Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

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

    • 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
    • Was this article helpful?
    //doorbell.io feedback widged