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

SiteApps Tables Missing - No Backup possible

Discussion in 'Plesk for Linux - 8.x and Older' started by sts85, Jan 19, 2008.

  1. sts85

    sts85 Guest

    0
     
    Hi,

    in my psa Database are some tables Missing.

    I'm running Plesk 8.3.0 on FedoraCore 6.

    When I try to maqke an Backup or some other operations, I get mysql errors, because some a table is missing. After Creating the 5th table by hand, I still became errors. It doesn't seem to end... ;) I gave up.

    Can Anybody post me an mysql dump for plesk 8.3.0 to create all neccessary tables?

    The Tables, that where/are missing:
    SiteApps
    SiteAppPackages
    APSLicenseTypes
    APSApplicationItems
    APSLicenseTypes
    APSClientApplicationItems


    thanks
    stephan
     
  2. DmitryT

    DmitryT Guest

    0
     
    stephan,

    this scripts are stored in /usr/local/psa/etc/db/psa_db.sql. For example, SiteApps table can be created:

    # less /usr/local/psa/etc/db/psa_db.sql | grep -i SiteApps

    CREATE TABLE SiteApps (
    id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
    -- installed application id
    , `app_release` VARCHAR(30) CHARACTER SET ascii COLLATE ascii_bin NOT NULL
    -- installed application release
    , dom_id INT UNSIGNED NOT NULL
    -- reference to domain, where application is installed
    , dom_type ENUM('domain', 'subdomain') NOT NULL DEFAULT 'domain'
    -- where application is installed
    , install_prefix VARCHAR(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL
    -- directory of application inside vhost
    , htdocs_directory ENUM('httpdocs', 'httpsdocs') NOT NULL DEFAULT 'httpdocs'
    -- which documents tree is used for application
    , capp_item_id INT UNSIGNED NOT NULL
    -- reference to application in client application pool
    , params_id INT UNSIGNED
    -- object id with values of parameters
    -- that are used for installed application
    , `license_id` INT UNSIGNED
    -- reference to APS License from pool
    , INDEX (capp_item_id)
    -- REFERENCES APSClientApplicationItems (id)
    , INDEX (params_id)
    -- REFERENCES Parameters (id)
    , INDEX (`license_id`)
    -- REFERENCES APSLicenses(id)
    ) TYPE=InnoDB;

    hope this will help.
     
Loading...