This document explains how to back up H-Sphere system and user data.

• Backing up system data
• Backing up user content

Backing Up System Data

H-Sphere (version 2.08 and higher) comes with a simple backup script. It requires postgresql client version 7.1 or higher installed and the psql program available in the system paths on the CP server.

The script is located at the /hsphere/shared/backup directory of the CP server and includes the following files:

hs_bck - the main script file
hs_bck.cfg - the script configuration file
hs_bck.txt - description/readme file.

The script backs up

1. H-Sphere properties file.
2. SiteStudio properties files.
3. OpenSRS configuration file (if it exists).
4. The main H-Sphere Postgresql DB.

This script does not back up the content of user directories, mail data and DNS settings. To back up user content, see below.

You can edit the hs_bck.cfg file to specify the backup storage directory, the number of latest backups to be stored (7 by default), the log file, etc.

Also, the 2.08 upgrade creates the /hsphere/shared/scripts/cron/hs_bck file which launches the backup script. For regular automatic backups, add the execution of this file into the CP server crontab configuration. For example, to run the backup script every day at 6:13 AM, you must add the following line:
13 6 * * * /hsphere/shared/scripts/cron/hs_bck >/dev/null 2>&1

These are the files and directories that are backed up by the script:

• H-Sphere and SiteStudio postgres DBs:
  • hsphere
  • counter
  • poll
  • guestbook
  
  
• H-Sphere and SiteStudio configuration files:
  • /hsphere/local/home/cpanel/shiva/psoft_config/*
  • /hsphere/shared/SiteStudio/psoft_config/*
  
  
• OpenSRS configuration file:
  • /etc/OpenSRS.conf

Backing Up User Content

Below is the list of databases, directories and files that need to be backed up in order to preserve all H-Sphere user data:

Control Panel Server

• dump all postgresql DBs and back up the postgres content directory (usually, /var/lib/pgsql on your CP server).
• ~cpanel/shiva/psoft_config/
• ~cpanel/shiva/shiva-templates/IMAGES/
• ~cpanel/shiva/custom/
• /hsphere/shared/SiteStudio/psoft_config
• /hsphere/shared/SiteStudio/var/websites/

Domain Name Server

• /etc/named.conf
• /hsphere/local/var/named/

Web Server

• /hsphere/local/home/ (users' dirs)
• /hsphere/local/config/ (httpd and ftp configs)
• /usr/local/frontpage/ (frontpage configs)

Mail Server

• ~vpopmail/domains/
• ~vpopmail/etc/
• ~qmaild/users/
• ~qmaild/controls/

MySQL Server

• ~mysql/

PostgeSQL Server

• Dump all user DBs at once with the pg_dumpall utility:
  pg_dumpall > db.out
  (pg_dumpall might need  to  connect  several  times  to  the PostgreSQL server,  asking  for  a  password each time. It is convenient to have the $HOME/.pgpass file in such cases. See man pg_dumpall for more details.)
• It is also very helpful to back up the postgres content directory (usually, /var/lib/pgsql on your PGSQL box).