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

Plesk 9.5.3 databes tables

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by keff, Feb 23, 2011.

  1. keff

    keff Basic Pleskian

    Dec 3, 2007
    Likes Received:
    My System:

    Debian 32-bit lenny
    Plesk 9.5.3

    Question is: how many tables have psa database?
    Today one of the users try to create web_user account in domain, but something goes wrong and plesk instead create web user change ftp_user of domain. When I search what's goes wrong I find, that the psa/sys_user table missing record with ftp_user of domain. Then I found that psa/accounts missing account for that user. And finaly whole home directory gone of this domain. Can't restore it from backup. Some errors shows the the directory missing or "Can't crate object, can't find record in SysUser table". I've restore missing record in database manually. From unpacked backup restore domain directory. Now everything seams to work, but I don't know how to check psa database.

    Best regards
    Last edited: Feb 23, 2011