How to restore WPB site from the snapshot

Created:

2016-11-16 12:40:17 UTC

Modified:

2017-04-24 12:15:50 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to restore WPB site from the snapshot

Applicable to:

  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Introduction.

Snapshots made for the Web Presence Builder (WPB) site are stored in the publishing location of the site. If site was removed from WPB it cannot be simply uploaded to WPB. This article describes procedure to manually restore WPB site from the saved snapshot if the site was removed from WPB.

Resolution

  1. Check whether there are snapshots for the site on the publishing location:

    # ls -la /var/www/vhosts/domain.tld/httpdocs/data/snapshots/
    total 252
    -rw-r--r-- 1 testcust psacln    223 Jul  1 13:34 03a21c5dbeaf22159bc109374638f61f_list.xml
    -rw-r--r-- 1 testcust psacln 250139 Jul  1 13:34 3b395edf0050931a8632de93a4d3085a.php
  2. Create a new instance of WPB site for the domain in Plesk:

    Websites & Domains , click WPB icon in the right side, matching the needed domain. Choose any template and create a site.

    Note: Do not publish it.

  3. Retrieve a new the site uuid from Plesk database:

    mysql> select dp.val as Site_uuid from dom_param dp join domains d on d.id=dp.dom_id where  dp.param='site_builder_site_id' and d.name='domain.tld';
    +--------------------------------------+
    | Site_uuid                            |
    +--------------------------------------+
    | 8f0ad6d8-485d-e553-25bd-feeef199f446 |
    +--------------------------------------+
    1 row in set (0.00 sec)`
  4. Define the location of WPB web site:

    mysql> select dir_name from site where uuid='8f0ad6d8-485d-e553-25bd-feeef199f446';
    +----------------------------------+
    | dir_name                         |
    +----------------------------------+
    | 3e7e3cde839d2002d223f4bab58e3eea |
    +----------------------------------+
    1 row in set (0.00 sec)
  5. Rename the XML file, containing snapshots list to make it fit the new dir_name :

    mv /var/www/vhosts/domain.tld/httpdocs/data/snapshots/03a21c5dbeaf22159bc109374638f61f_list.xml /var/www/vhosts/domain.tld/httpdocs/data/snapshots/3e7e3cde839d2002d223f4bab58e3eea_list.xml
  6. Make sure that this list is well formed and available, according to the KB article:

    #213914545 Why aren't site snapshots shown on the Revert page?

  7. Refresh the page with new site instance. Snapshots should be available now. As soon as they are available in WPB, you can restore them.

    The method is the same in POA, but the only difference is publishing location path.

    NOTE: After the snapshot is restored, there could be an additional issue with site images, because images may have old location paths in WPB database. Due to this, they may be not wisible in the restored site in WPB.

    To solve this, you can either re-upload images anew, or change paths in database:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` --disable-extended-insert  sitebuilder5 > sb_backup.sql

    grep "03a21c5dbeaf22159bc109374638f61f" sb_backup.sql|grep widget_property

    INSERT INTO `widget_property` VALUES (570,462,'content','<p><img id=\\"mce-548\\" style=\\"float: left; margin-right: 20px;\\" title=\\"helloworld\\" src=\\"/sitebuilder/sites/03/03a21c5dbeaf22159bc109374638f61f/attachments/Image/helloworld.jpg\\" alt=\\"helloworld\\" width=\\"1631\\" height=\\"743\\" /></p>');

    Find the strings with old paths, and replace them by new values, from

    /sitebuilder/sites/03/03a21c5dbeaf22159bc109374638f61f/attachments/Image/helloworld.jpg

    to

    /sitebuilder/sites/3e/3e7e3cde839d2002d223f4bab58e3eea/attachments/Image/helloworld.jpg
Have more questions? Submit a request
Please sign in to leave a comment.