• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

HELP! something wrong with mysql and plesk admin

L

leisegang

Guest
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
 
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.
 
Back
Top