Unable to access Plesk: Table 'psa.table_name' doesn't exist

Follow

Comments

3 comments

  • Avatar
    Sharul Hafiz

    I've got this error when trying to restore the database

    ERROR 1813 (HY000) at line 15: Tablespace for table '`psa`.`APSApplicationItems`' exists. Please DISCARD the tablespace before IMPORT

    Moving out all content from psa folder sort of solve it. Is that the correct way to solve it?

    0
    Comment actions Permalink
  • Avatar
    Anton Maslov

    Sharul, error might have different reason behind, thus hard to evaluate your solution. 

    What I'd like to recommend is please check MySQL:

    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqlcheck -u admin --all-databases

    And if you'll see errors about non-existing databases or others you might need to do a recovery:

    https://support.plesk.com/hc/en-us/articles/213939865-How-to-fix-InnoDB-corruption-cases-for-the-MySQL-databases-on-Plesk-for-Linux-

    0
    Comment actions Permalink
  • Avatar
    Sepehr Ashoori

    I get ERROR 1045 (28000): Access Denied for user 'admin'@'localhost' (using password: YES) when I execute the zcat mysql.daily.dump ....

    Please help.

    My problem:

    DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.misc' doesn't exist, query was: replace into misc (param, val) values(:param, :val)
    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request