How to Restore the H-Sphere System Database ?

The H-Sphere backup location is set in the /hsphere/shared/backup/hs_bck.cfg config file. The default location is /var/backup.

hs_bck stores the system data backup (with user content if configured in hs_bck.cfg) in the following files in the BCK_DIR directory:

<ARCHIVE>.tgz – the latest backup; <ARCHIVE> is the name of the backup file set in hs_bck.cfg. This is the default name:
BACKUP hs_bck
Older backup files are named <ARCHIVE>.1.tgz, <ARCHIVE>.2.tgz, …
hsphere.sql – the H-Sphere system database backup;
counter.sql, poll.sql, guestbook.sql – SiteStudio system databases are also backed up if SiteStudio is integrated with H-Sphere.

Restoring The H-Sphere System Database

The H-Sphere system database restore is described here.

Restoring System Data

Untar <ARCHIVE>.tgz in the H-Sphere backup directory. System data is restored to the corresponding locations on the CP server:

~cpanel/shiva/psoft_config/ (H-Sphere configuration files)
~cpanel/shiva/shiva-templates/IMAGES/ (H-Sphere and custom images)
~cpanel/shiva/custom/ (customization directory)
/hsphere/shared/SiteStudio/psoft_config/ (SS config)
/hsphere/shared/SiteStudio/var/websites/ (SS sites)

And how to Restore User Content ?

Restoring User Content

Untar <ARCHIVE>.tgz in the H-Sphere backup directory on a box you wish to restore user content. User content is restored to the corresponding locations:

DNS 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/control/
MySQL server:

~mysql/

PostgreSQL server:

For Linux servers:
~postgres/
For FreeBSD servers:
~pgsql/