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

[Otto Dassau]

Hi Tim and Gerry,

On Fri, 6 Jun 2008 17:48:41 +0200
"Tim Sutton" <tim at linfiniti.com> wrote:

> Hi
> 
> I didnt reveive the backup yet. 

sorry - used a wrong mail address, now it should work.

> 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.

yes ok, you mean we then use the mirrors as backup? So until Gerry's mirror
works I rsync the folder on my server, too. 

@Gerry. Thanks a lot for your offer to provide a QGIS mirror and I can of course
help to coordinate it with you.

thanks
 Otto

> 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
> >
> 
> 
>