Backup and Restore
 
Backup

To backup all data in Confixx, use this command:
/root/confixx/backup.pl --dump /path/to/confixxbackup


Restore

To perform a restore, it is always recommended to first backup all data and then perform a fresh installation of Confixx, upgraded to the newest version.
In the restore process, a map-file needs to be created first:
cd /root/confixx
./restore.pl --mapping --dump /path/to/confixxbackup.tgz --map my_map.map


After that, you can edit the map file, meaning you can decide, which data should be mapped to which account, and maybe exclude some data.

Now that the mapfile should be ok, you can restore the data using this command:
./restore.pl --restore --dump /path/to/confixxbackup.tgz --map my_map.map

When I restore a Confixx database, I usually delete the target server's old stuff with the "--clean"-Option. You need to give this option when creating the mapping file and when actually restoring:
/root/confixx/restore.pl --mapping --dump /test/bkup/confixxbackup.tgz --map /test/restore.txt --clean
/root/confixx/restore.pl --restore --dump /test/bkup/confixxbackup.tgz --map /test/restore.txt --clean

Some entries in mapping file you'll have to check:
domain(<standarddomainname>).suffix
service(statistik).state    =    value(0)
service(idn).state   =    value(0)
service(phpmyadmin).state    =    value(0)
mysql(*).Password   =    rule(restore_dumped)


Don't forget to comment out Confixx counterscript in crontab during Restore. This can be done in /etc/crontab or in certain environments with the command crontab -e.


Possible errors:

DBD::mysql::st execute failed: Duplicate entry '15-e964d0a0246b9d099927b8dd644977ab' for key 1 at /opt/confixx/Modules/Restore/Tables/Common.pm line 94. Can not execute query 'INSERT INTO custom_skins
Fix:
In restore.txt, look for:
skins(*).default = rule(assign_current)
and replace with:
skins(*).default = rule(restore_dumped)

DBD::mysql::st execute failed: Unknown column 'speichertag' in 'field list' at /root/confixx/Modules/Restore/Tables/Common.pm line 154.
Fix:
Create the needed MySQL columns:
mysql -p<root_password> confixx
mysql> ALTER TABLE `zeiten` ADD `httpdtraffiktag` tinyint(4) DEFAULT '0' NOT NULL;
mysql> ALTER TABLE `zeiten` ADD `speichertag` tinyint(4) DEFAULT '0' NOT NULL;
mysql> ALTER TABLE `zeiten` ADD `ftptraffiktag` tinyint(4) DEFAULT '0' NOT NULL;
mysql> exit



If you have to manually look into a backup archive that is archived in multiple files (confixx splits backup archives into 2GB parts) use the following command:
cat confixxbackup.tgz.a* >> /dev/stdout | tar -xzf /dev/stdin
this will untar a multi-file backup archive consisting of for example the files confixxbackup.tgz.aa, confixxbackup.tgz.ab and confixxbackup.tgz.ac.


Useful information:
http://www.blogix.net/2008/06/22/confixx-backup-restore/
 
admin / Dec 10, 2008
   
 
 
Login: 
Pass: 
 
 
     
     
2004 - 2019 / lookass.ch
makememad@lookass.ch