Error 1146 starting psa: tables missing ?

[kaboom]

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

 

[igors]

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.

 

[kaboom]

But there isn't an older backup Can i restore it from a different server ?

 

[kaboom]

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