How to restore a deleted Web Presence Builder site from a snapshot located in a domain folder?

1. Connect to the server via SSH and check snapshot name:

   # ls -la /var/www/vhosts/example.com/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

   Here, 03a21c5dbeaf22159bc109374638f61f is the ID of the old site that was published to the domain example.com.

2. Create a new instance of the WPB site for the domain example.com via Plesk in Domains > example.com > Edit in Web Presence Builder.

   Warning: Do not publish the site yet.

3. Find the Site ID by the name of the Plesk domain:

   # plesk db
   mysql> select d.name as 'Plesk Domain', s.uuid as 'Site uuid', s.site_id as 'Site ID' from psa.domains d, psa.dom_param dp, sitebuilder5.site s where d.id=dp.dom_id and dp.param='site_builder_site_id' and s.uuid=dp.val and d.name='example.com';
   +--------------+--------------------------------------+----------------------------------+
   | Plesk Domain | Site uuid | Site ID |
   +--------------+--------------------------------------+----------------------------------+
   | example.com | d116751c-458c-5179-3f57-142135a67b3c | 172bc09617fa3dcafded8e53377097d5 |
   +--------------+--------------------------------------+----------------------------------+

4. Rename the XML file to make it fit the new Site ID:

   # mv /var/www/vhosts/example.mom/httpdocs/data/snapshots/03a21c5dbeaf22159bc109374638f61f_list.xml /var/www/vhosts/example.com/httpdocs/data/snapshots/172bc09617fa3dcafded8e53377097d5_list.xml

5. Refresh the page with the new site instance. Snapshots should be shown on the "Revert" page. As soon as they are available in WPB, you can restore them by clicking Load.

Note: After the snapshot is restored, there may be additional issues with site images because they have the old location paths in the WPB database. As a result, they may not be visible in the restored site.
To solve this, re-upload the images or change the paths in the database:

# mysqldump --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 the old paths and replace them with the new values. For example, change /sitebuilder/sites/03/03a21c5dbeaf22159bc109374638f61f/attachments/Image/helloworld.jpg to /sitebuilder/sites/17/172bc09617fa3dcafded8e53377097d5/attachments/Image/helloworld.jpg.

1. Connect to the server via RDP

2. Check the snapshot name at %plesk_vhosts%example.com\httpdocs\data\snapshots, e.g. 03a21c5dbeaf22159bc109374638f61f_list.xml, where 03a21c5dbeaf22159bc109374638f61f is the ID of the old site that was published to the domain example.com

3. Create a new instance of the WPB site for the domain example.com via Plesk in Domains > example.com > Edit in Web Presence Builder

   Note: Do not publish the site yet.

4. Find the Site ID by the name of the Plesk domain: to access sitebuilder5 database on Windows, execute the following command via the command line:

   "%plesk_dir%\MySQL\bin\mysql.exe" -D sitebuilder5 -usitebuilder -p<sitebuilder_password> -P 3306

   The sitebuilder_password is located in the %plesk_dir%\sb\config file.

5. Execute the following command for example.com:

   mysql> select uuid,site_id from site where site_publish_settings_id=(select id from site_publish_settings where url like "%example.com%") \G
   *************************** 1. row ***************************
   uuid: 39ce7af2-a526-42e6-e3f6-2b04377c47e7
   site_id: afdef54d44d8be6d83df5bd6ab10a157

   The site ID is afdef54d44d8be6d83df5bd6ab10a157

6. Rename the XML file from %plesk_vhosts%example.com\httpdocs\data\snapshots directory to make it fit the new Site ID

7. Refresh the page with the new site instance. Snapshots should be shown on the "Revert" page. As soon as they are available in WPB, you can restore them by clicking Load.

Note: After the snapshot is restored, there may be additional issues with site images because they have the old location paths in the WPB database. As a result, they may not be visible in the restored site. To solve this, re-upload the images or change the paths in the database:

1. Create a sitebuider database dump:

   "%plesk_dir%\Mysql\bin\mysqldump.exe" -usitebuilder -p<sitebuilder_password> -P 3306 sitebuilder5 > C:\FULL\PATH\TO\FILE_NAME.sql

2. Open the dump in any text editor and change the old paths and replace them with the new values. For example, change /sitebuilder/sites/03/03a21c5dbeaf22159bc109374638f61f/attachments/Image/helloworld.jpg to /sitebuilder/sites/17/172bc09617fa3dcafded8e53377097d5/attachments/Image/helloworld.jpg.