Article ID: 6261, created on Apr 17, 2009, last review on Apr 16, 2012

  • Applies to:
  • Plesk Sitebuilder 4.5 for Linux/Unix

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>&#160;</div>
<div>&#160;</div>
<br />
<div>&#160;</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>.xml

Where <sb_root> is Sitebuilder installation directory:

 - /usr/local/sitebuilder for RedHat-like operating systems and FreeBSD;
 - /opt/sitebuilder/ for Debian and Ubuntu.

f7f840260c1591440648a375a64b5b75 fad6dc0c8e983c17ae70a51ac7952cd0 d055be4fdc562a8ecb8e6d0bf419f946 ea6a61e571a858aa6019ceb068ea403a 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF