1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

HELP! something wrong with mysql and plesk admin

Discussion in 'Plesk for Linux - 8.x and Older' started by leisegang, Nov 28, 2006.

  1. leisegang

    leisegang Guest

    0
     
    I got this in my face this morning:

    -------------

    ERROR: PleskMainDBException
    MySQL query failed: Can't find file: 'misc.MYI' (errno: 2)

    0: /opt/psa/admin/plib/common_func.php3:229
    db_query(string 'select param, val from misc')
    1: /opt/psa/admin/plib/common_func.php3:467
    get_param(string 'mysql41_compatible')
    2: /opt/psa/admin/plib/common_func.php3:364
    db_set_names()
    3: /opt/psa/admin/plib/common_func.php3:343
    db_connect_real(string 'localhost', string 'admin', string '***********', string 'psa')
    4: /opt/psa/admin/plib/common_func.php3:323
    db_connect()
    5: /opt/psa/admin/auto_prepend/auth.php3:85
     
  2. Limedrink

    Limedrink Guest

    0
     
    Looks like your psa database is corrupt.

    Login to the server, and you can retrieve a working database from the daily backups at:

    /var/lib/psa/dumps/

    Use the mysql command line tool to clear the psa database, and import one of the backups (after you un-gzip one of them).

    Let me know if you need any more assistance in doing that.


    Regards,

    Limedrink.
     
Loading...