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

Error 1146 starting psa: tables missing ?

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by kaboom, Sep 7, 2009.

  1. kaboom

    kaboom Guest

    0
     
    I got this problem on a Centos 5 server running Plesk 9.2.2:

    /etc/rc.d/init.d/psa start
    Starting xinetd service... done
    Starting named service... done
    Starting mysqld service... done
    Starting postgresql service... not installed
    Starting psa-spamassassin service... not installed
    Plesk: Starting Mail Server... already started
    ERROR 1146 (42S02) at line 1: Table 'psa.DomainServices' doesn't exist
    Starting mail handlers tmpfs storage
    ERROR 1146 (42S02) at line 1: Table 'psa.sessions' doesn't exist
    Starting Plesk... done
    ERROR 1146 (42S02) at line 1: Table 'psa.misc' doesn't exist

    Anyone knows how to fic this problem?

    Thanks in advance,
    Regards Tom
     
  2. igors

    igors Basic Pleskian

    20
    37%
    Joined:
    Sep 1, 2009
    Messages:
    32
    Likes Received:
    0
    Hi,

    Parallels Plesk creates dump of its mysql database daily and stores it under /var/lib/psa/dumps/
    You can get latest dump and restore missing tables from it.
     
  3. kaboom

    kaboom Guest

    0
     
    But there isn't an older backup :( Can i restore it from a different server ?
     
  4. kaboom

    kaboom Guest

    0
     
    Problem solved, I deleted 3 id* (innodb) files in /var/lib/mysql but restored them from backup and everything is working again.
     
Loading...