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


Discussion in 'Sitebuilder 3.0 for Linux' started by bartje3, Feb 20, 2007.

  1. bartje3

    bartje3 Guest


    It seems that SB3 doesn't have any backup capabillities anymore, so I want to write a backup script for daily backups.
    Can someone tell me which directories has to be back-upped and how to exclude trial sites from backup ?

    Thank you, regards,

  2. Dmitry Frantsev

    Dmitry Frantsev Golden Pleskian

    Sep 19, 2005
    Likes Received:
    As I know next Sitebuilder version 4 will have backup option. As for now if you wish to backup Sitebuilder sites you need backup /usr/local/sitebuilder/htdocs/sites (be default) directory and Sitebuilder database.
    Each site has it's owner and you can distinguish trial site from regular by this owner. In mysql table 'site' all sites are listed. Each site has 'user_id'. List of users can be found in 'user' table. And if sites is owned by user 'NAME_guest' it means that this site is trial. In mysql it should be something like following request:

    mysql> select s.alias from site s, user u where s.user_id=u.id and u.user_name like "%guest%";

    This command should output you the list of trial sites.
    Hope this information will be helpful for you.
  3. bartje3

    bartje3 Guest


    Thank you ! This helped me a lot.
    If you are already working on V.4 I have some suggestions:

    - permissions on sites incorrect after migration from V.2(rwxrwxrwx)
    - blank page when clicking "publish" (but website was published)
    - edit page changes text-type in table cell when a link name has a space (but the published linkname is correct).