[BlueOnyx:07705] Re: Transferring DB backups over FTP

[Christoph Schneeberger]

Hi Richard,

Many thanks for your contribution and for allowing us to add it to the
webpage.
The package will be adapted to 5107R soon.

Thanks again,
Christoph

Richard Morgan wrote:
> Hi
>  
> This is for anyone that uses Telemedia's rather lovely MySQL backup
> package: http://www.telemedia.ch/publ/blueonyx-mysqlbackup.html (I
> hope they do a 5107R version ;o) ).
>  
> They have a feature to run post backup scripts that are stored at
> /usr/local/sbin/bo-backupmysql.post so, I wrote something to FTP it
> across the network to another server.  It doesn't delete anything once
> it gets old, it's just a hack to make sure we've got a copy in a
> different place.  I'm posting it here in case anyone finds it useful.
>  
> As root, do:
>  
> pico /usr/local/sbin/bo-backupmysql.post
>  
> Copy the script below in to the editor and modify the ftp details
>  
> Hope someone finds it useful.
>  
> Richard
>  
> ---
>  
> echo "-----";
> echo "$FNAME.tar.gz will be sent to an FTP server";
>
> FTP_HOST=nnn.nnn.nnn.nnn
> FTP_USER=username
> FTP_PASS=password
> FTP_PATH=/database_backups
>
> ncftpput -m -u $FTP_USER -p $FTP_PASS $FTP_HOST $FTP_PATH $FNAME.tar.gz
>  
> echo "$FNAME.tar.gz stored on $FTP_HOST at $FTP_PATH";
> echo "-----";
>  
>  
>  
>  
> ------------------------------------------------------------------------
>
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx
>   

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20110719/d568adc2/attachment.html>