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

[Otto Dassau]

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
>