<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type><BASE
href="file://C:\Program Files\Common Files\Microsoft Shared\Stationery\">
<STYLE>BODY {
BACKGROUND-REPEAT: no-repeat; FONT-FAMILY: Arial; BACKGROUND-POSITION: left top; COLOR: #000000; FONT-SIZE: 10pt
}
</STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.19088"></HEAD>
<BODY bgColor=#ffffff>
<DIV>Hi</DIV>
<DIV> </DIV>
<DIV>This is for anyone that uses Telemedia's rather lovely MySQL backup
package: <A
href="http://www.telemedia.ch/publ/blueonyx-mysqlbackup.html">http://www.telemedia.ch/publ/blueonyx-mysqlbackup.html</A>
(I hope they do a 5107R version ;o) ).</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>As root, do:</DIV>
<DIV> </DIV>
<DIV>pico /usr/local/sbin/bo-backupmysql.post</DIV>
<DIV> </DIV>
<DIV>Copy the script below in to the editor and modify the ftp details</DIV>
<DIV> </DIV>
<DIV>Hope someone finds it useful.</DIV>
<DIV> </DIV>
<DIV>Richard</DIV>
<DIV> </DIV>
<DIV>---</DIV>
<DIV> </DIV>
<DIV>echo "-----";<BR>echo "$FNAME.tar.gz will be sent to an FTP server";</DIV>
<DIV><BR>FTP_HOST=nnn.nnn.nnn.nnn</DIV>
<DIV>FTP_USER=username<BR>FTP_PASS=password<BR>FTP_PATH=/database_backups</DIV>
<DIV><BR>ncftpput -m -u $FTP_USER -p $FTP_PASS $FTP_HOST $FTP_PATH
$FNAME.tar.gz</DIV>
<DIV> </DIV>
<DIV>echo "$FNAME.tar.gz stored on $FTP_HOST at $FTP_PATH";<BR>echo
"-----";</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>