[QUOTE=IWorx-Socheat;9686]Think of “structure” only as backing up the core information of the SiteWorx account, the information that’s stored in the internal InterWorx database, which you normally don’t have access to.
For example, we’ve personally found it very useful for sites with extremely large databases (2GB or more). We can quickly backup and import the “structure” of a SiteWorx account (email accounts, database names and passwords, ftp accounts, quota limits, etc), and then we can just copy the database data directory (/var/lib/mysql/uniqname_dbname) over to the new server.
Yes it might be usefull, but maybe not for a complete backup and recovery plan.
I’d do some tests to see if doing a structure only backup for a all accounts + rsync/tar to a NAS all needed directories (home;vpopmai;qmail,var/spool/cron) is speedest than just doing a full backup of all accounts… Not sure
I still looking for the best backup/recovery plan for cases like :
- 1 hdd crash --> raid is one solution
- 2 hdd crash --> full backup is needed *
- kernel panic --> full backup is needed *
- files corruption --> partial backup is ok
- full backup = siteworx accounts backups (or home;users db; vpopmail; etc); interworx db, iworx ini; some etc files
Today we do two kinds of backups:
1- We tar.gz some important directories
- Interworx DB ( /usr/local/interworx/var/lib/mysql/* )
- Interworx config ( /usr/local/interworx/iworx.ini )
- Users DB (/var/lib/mysql/*)
- Some ETC files (etc/passwd /etc/group /etc/shadow /etc/hosts.allow /etc/hosts.deny /etc/resolv.conf /etc/hosts /etc/proftpd.conf)
- Qmail files (/var/qmail/*)
- Vpopmail files (/var/vpopmail/*)
2- we do a full siteworx accounts backups, then tar.gz thz dir
3 - copy all these tar.gz files to a NAS location
Like this we have all siteworx accounts backuped, so we can do a simple restore of one or more siteworx accounts if needed. If we have a migration to do we have all data and we can choose to import all siteworx accounts from the full backup or to manually copy the iworx db, iworx ini, user db then construct the home dir and data from the full siteworx account backup.
Indeed we do not tar.gz the home dir it really take to long, so we use the full siteworx backup to create it (not so cool, but…)
It is not the best backup and recovery plan, but it did already help us.
If you have better solution, do not hesitate to share with us what is the best backup/recovery plan for you