[BlueOnyx:07685] Transferring DB backups over FTP

[Richard Morgan]

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



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