Cedeus DB backups - Revision history

StefanS: /* Data to backup */

2015-08-11T18:42:05Z

‎Data to backup

StefanS: /* Data to backup */

2015-05-28T15:05:32Z

‎Data to backup

StefanS: /* Elgg HP backup summary */

2015-05-28T14:56:33Z

‎Elgg HP backup summary

StefanS: /* Elgg miCiudad backup summary */

2015-05-28T14:55:59Z

‎Elgg miCiudad backup summary

StefanS: /* Elgg HP backup summary */

2015-05-28T14:33:02Z

‎Elgg HP backup summary

StefanS: /* Backup of Elgg miCiudad - on CedeusGeonode VM (15080) */

2015-05-28T14:30:24Z

‎Backup of Elgg miCiudad - on CedeusGeonode VM (15080)

StefanS: /* Data to backup */

2015-05-13T17:05:50Z

‎Data to backup

StefanS: /* Data to backup */

2015-05-13T13:33:16Z

‎Data to backup

StefanS: /* Data to backup */

2015-05-12T15:44:07Z

‎Data to backup

StefanS: /* Data to backup */

2015-05-12T15:35:36Z

‎Data to backup

@@ Line 110: / Line 110: @@
 *#: <code>40 12 12 * * tar -cvzf /home/ssteinig/geoserverImageDataBackup.tgz /var/www/geoserver/ > /home/ssteinig/imagetar.log</code>
 *: => These tar files need to be copied by hand to CedeusGeoNode's  ''/home/cedeusdbbackupuser/geonode_one_time_backup/'', e.g. with "<code>scp -i /home/ssteinig/.ssh/id_rsa /home/ssteinig/geoserverDataBackup.tgz   cedeusdbbackupuser@146.155.17.19:/home/cedeusdbbackupuser/geoserverbackup</code>"
-*We will backup a couple of folders that can change frequently:
+*We will '''backup''' a couple of folders that can change '''frequently''':
 *# GeoServer (i.e. rasters, gwc layers, map styles, etc.): "<code>sudo tar -cvzf /home/ssteinig/geoserverDataBackup.tgz /usr/share/geoserver/data/</code>"
 *#: ... copied to ''/home/cedeusdbbackupuser/geoserverbackup/''.

@@ Line 107: / Line 107: @@
 *# Eventually there are data in ''/var/lib/geoserver/geonode-data/'', for instance the printing setup file config.yaml. So one should also do a once-in-a-while backup: "<code>sudo tar -cvzf /home/ssteinig/geonodeDataBackup.tgz /var/lib/geoserver/geonode-data/</code>"
 *# Image and satellite data that I stored under ''/var/www/geoserver/''. Do this only once in a while as folders may be huge, e.g. the folder with the Sectra 2012 Santiago aerial images in GeoTIFF format (212 images) has a size of . Use: "<code>sudo tar -cvzf /home/ssteinig/geoserverImageDataBackup.tgz /var/www/geoserver/</code>"
-*#: => The tar file can be created as a cron job [''its currently disabled due to impractical file size of 222GB'' !!!] for the 1st day for each month, at 12:40 (mittags) as tar creation takes quite some time (so one can not stay logged in to run it from command line). The used crontab command is:
+*#: => The tar file can be created as a cron job [''its currently disabled due to impractical file size of 222GB'' !!!] for the 12th day for each month, at 12:40 (mittags) as tar creation takes quite some time (so one can not stay logged in to run it from command line). The used crontab command is:
 *#: <code>40 12 12 * * tar -cvzf /home/ssteinig/geoserverImageDataBackup.tgz /var/www/geoserver/ > /home/ssteinig/imagetar.log</code>
 *: => These tar files need to be copied by hand to CedeusGeoNode's  ''/home/cedeusdbbackupuser/geonode_one_time_backup/'', e.g. with "<code>scp -i /home/ssteinig/.ssh/id_rsa /home/ssteinig/geoserverDataBackup.tgz   cedeusdbbackupuser@146.155.17.19:/home/cedeusdbbackupuser/geoserverbackup</code>"

@@ Line 169: / Line 169: @@
 * server: CedeusGeoNode
 * cron job running nightly at 1:35am
-* using the script ''home/MyUser/backupscripts_inuse/createelggbackup.sh'' (run as sudo crontab; reason see above)
+* using the script ''home/MyUser/backupscripts_inuse/createelggbackup.sh'' (run in root crontab; reason see above)
 * copies the three files to CedeusGeoNode into folder ''/home/cedeusdbbackupuser/elgghpbackups/''

@@ Line 155: / Line 155: @@
 * server: CedeusGeoNode on elgg VM (15080)
 * cron job running nightly at 1:45am
-* using the script ''createmiciudadbackup.sh''
+* using the script ''createmiciudadbackup.sh'' (run in root crontab)
 * copies the three files to CedeusGeoNode into folder ''/home/cedeusdbbackupuser/miciudadbackups/''

@@ Line 169: / Line 169: @@
 * server: CedeusGeoNode
 * cron job running nightly at 1:35am
-* using the script ''createelggbackup.sh''
+* using the script ''home/MyUser/backupscripts_inuse/createelggbackup.sh'' (run as sudo crontab; reason see above)
 * copies the three files to CedeusGeoNode into folder ''/home/cedeusdbbackupuser/elgghpbackups/''

@@ Line 151: / Line 151: @@
 => Hence, I am running the script as '''root''' in the ''root crontab'' instead - with <code>sudo crontab -e</code> .
-==== Elgg backup summary ====
+==== Elgg miCiudad backup summary ====
 * server: CedeusGeoNode on elgg VM (15080)
@@ Line 157: / Line 157: @@
 * using the script ''createmiciudadbackup.sh''
 * copies the three files to CedeusGeoNode into folder ''/home/cedeusdbbackupuser/miciudadbackups/''
 === MySQL dump for Mediawiki(s) - on CedeusGeonode VM (22080 vs. 21080) ===