View Single Post
  #6 (permalink)  
Old 09-20-2007, 05:36 AM
alemcherry alemcherry is offline
Senior Member
 
Join Date: May 2007
Posts: 334
Default

Quote:
Originally Posted by brinks View Post
Can we also Back Up User Content ?

Yes, u can Back 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.

You can back them up either manually or by the means of the /hsphere/shared/backup/hs_bck script running locally on H-Sphere servers. To configure the script to back up user content, add the corresponding directories to the /hsphere/shared/backup/hs_bck.cfg config file (see /hsphere/shared/backup/hs_bck.txt for the script options).

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/
If the database is large, the dump can take several hours to complete. You can speed it up by setting
fsync=off
in postgresql.conf. When you are done, unset this option back for safety reasons.

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

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.)

Note: dump file is created with 644 permissions by default; you need to set more secure 600 permissions to prevent the data from being read by other users:
chmod 600 db.out
It is also very helpful to back up the postgres content directory (usually, /var/lib/pgsql on your PGSQL box).
Reply With Quote