[Qgis-community-team] Example backup script for joomla

[Tim Sutton]

Hi

I didnt reveive the backup yet. For backing up the web folder itself,
I suggest that we just use some rsync scripts to clone it over to
additional servers. I cc'd you a message to Gerry the other day who is
also willing to host a mirror. I'll set up my server to rsync weekly
too.

Regards

Tim

2008/6/6 Otto Dassau <otto.dassau at gmx.de>:
> Hi Tim,
>
> ok I adjusted the automysqlbackup.sh script on xblade14-2 (/osgeo/qgis/scripts)
> according to your suggestions. It now sends now mysql dump files and a log to
> you, Stephan. I guess this should work. You and Stephan should have received a
> first mail with a dump now.
>
> And do we have a special place for qgis backups where we can also put a backup
> of the new joomla installation folder /osgeo/qgis/qgis-web?
>
> regards,
>  Otto
>
> On Fri, 6 Jun 2008 16:41:59 +0200
> "Tim Sutton" <tim at linfiniti.com> wrote:
>
>> Hi Otto (and anyone else interested)
>>
>> Here is the backup script I wrote on the qgis.org server to send
>> myself a nightly backup of the mysql database:
>>
>> QGIS_MYSQL=/backups/joomla_qgis_backup.`date +%d%m%Y`.sql
>> mysqldump -uroot -S /chroot_postgis/var/run/mysqld/mysqld.sock -e -c
>> -Q --allow-keywords --add-drop-table -pbar joomla_qgis > ${QGIS_MYSQL}
>> gzip -f ${QGIS_MYSQL}
>> FILENAME=${QGIS_MYSQL}.gz
>> mpack -s "Daily QGIS.org Mysql backup for `date +%d-%m-%Y`" $FILENAME
>> tim at linfiniti.com
>>
>> Note :
>> - you can use a comma delimited list for the recipients on the last line.
>> - you need 'mpack' installed to ba able to package the backup into an
>> email attachment from the command line
>> - I was using mysql on unix socket rather than on tcp/ip port so you
>> will need to adjust / remove the mysqldump -S parameter
>> - make sure the other mysql dump parameters are included otherwise
>> joomla backup will not restore cleanly since in some cases they used
>> sql reserved words for field names etc.
>> - replace -pbar with -p<yourpassword>
>>
>> Regards
>>
>> Tim
>>
> _______________________________________________
> Qgis-community-team mailing list
> Qgis-community-team at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-community-team
>



-- 
Tim Sutton
QGIS Project Steering Committee Member - Release Manager
Visit http://qgis.org for a great open source GIS
openModeller Desktop Developer
Visit http://openModeller.sf.net for a great open source ecological
niche modelling tool
Home Page: http://tim.linfiniti.com
Skype: timlinux
Irc: timlinux on #qgis at freenode.net