Symptoms
If we restore any user with sites from backup, the site is empty and there are only files in __edit directory:-bash-3.00# ls -la <sb_root>/htdocs/sites/5c/5cd9eb055396ecf7c5b56ad9181cc2e1
total 24
drwxr-xr-x 6 apache apache 4096 Apr 16 11:38 .
drwxr-xr-x 7 apache apache 4096 Apr 16 11:05 ..
drwxr-xr-x 5 apache apache 4096 Apr 16 11:38 __edit
drwxr-xr-x 2 apache apache 4096 Apr 16 11:05 attachments
drwxr-xr-x 3 apache apache 4096 Apr 16 11:38 customImages
drwxr-xr-x 5 apache apache 4096 Apr 16 11:05 data
-bash-3.00# ls -la <sb_root>/htdocs/sites/5c/5cd9eb055396ecf7c5b56ad9181cc2e1/__edit/
total 148
drwxr-xr-x 5 apache apache 4096 Apr 16 11:38 .
drwxr-xr-x 6 apache apache 4096 Apr 16 11:38 ..
lrwxrwxrwx 1 apache apache 83 Apr 16 11:38 attachments -> <sb_root>/htdocs/sites/5c/5cd9eb055396ecf7c5b56ad9181cc2e1/attachments
-rw-r--r-- 1 apache apache 4762 Apr 16 11:38 config.php
lrwxrwxrwx 1 apache apache 71 Apr 16 11:38 css -><sb_root>/htdocs/templates/art_and_photography-003/red/css
drwxr-xr-x 3 apache apache 4096 Apr 16 11:38 data
drwxr-xr-x 3 apache apache 4096 Apr 16 11:38 images
-rw-r--r-- 1 apache apache 11359 Apr 16 11:38 index.php
-rw-r--r-- 1 apache apache 4622 Apr 16 11:38 init.php
-rw-r--r-- 1 apache apache 402 Apr 16 11:38 menu.xml
-rw-r--r-- 1 apache apache 11359 Apr 16 11:38 page0.php
-rw-r--r-- 1 apache apache 11120 Apr 16 11:38 page1.php
-rw-r--r-- 1 apache apache 11150 Apr 16 11:38 page2.php
-rw-r--r-- 1 apache apache 11100 Apr 16 11:38 page3.php
-rw-r--r-- 1 apache apache 11100 Apr 16 11:38 page4.php
-rw-r--r-- 1 apache apache 11108 Apr 16 11:38 page5.php
-rw-r--r-- 1 apache apache 11112 Apr 16 11:38 page6.php
drwxr-xr-x 6 apache apache 4096 Apr 16 11:38 resources
-rw-r--r-- 1 apache apache 1660 Apr 16 11:38 server.php
-bash-3.00#The restoration completed without an error.
Cause
That is normal. Site content is stored in Sitebuilder database. It is compiled anew every time you open site in Sitebuilder Wizard and put to directory __edit. On published site images that were uploaded to Image Gallery or eShop are stored on the published host.In the following way you may get site content from the database.
To get id of root page of site <SITE NAME>:
mysql> select site_page_id from site where alias='<SITE NAME>';
+--------------+
| site_page_id |
+--------------+
| 180 |
+--------------+
1 row in set (0.00 sec)
mysql>To get content of all pages that belong to the site:
mysql> select title, content from site_page where parent_id in (select id from site_page where parent_id = 180) or parent_id = 180 order by id;
+-----------+-----------------------------------------------------------------+
| title | content |
+-----------+-----------------------------------------------------------------+
| Home | <div> </div>
<div> </div>
<br />
<div> </div> |
| About Me | <p>Type Content Here</p> |
| Photos | |
| eShop | |
+-----------+-----------------------------------------------------------------+
5 rows in set (0.00 sec)
mysql>The site may have pages with large content, so be aware that the output is big.
Additional information
You may use the following command to restore user <USER NAME> from backup <BACKUP FILE>.xml:~# <sb_root>/utils/sbrestore user --name=<USER NAME> --with-sites --with-site-content --recursive --input=<BACKUP FILE>.xmlWhere <sb_root> is Sitebuilder installation directory:
- /usr/local/sitebuilder for RedHat-like operating systems and FreeBSD;
- /opt/sitebuilder/ for Debian and Ubuntu.