<?xml version="1.0" ?><html>
<head>
<title></title>
</head>
<body>
<div align="left"><font face="Arial"><span style="font-size:10pt">Hi Stephen</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> Two new documents have been loaded on http://www.kohadocs.org: </span></font></div>
<div align="left"><font face="Arial" color="#7f0000"><span style="font-size:10pt">> "Updating Koha" and "Backups and Restoring," both by Joshua Ferraro. </span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">I was using a little script to backup koha's database it is similar to yours at documentation. I
was working it as a cron job every evening at 8 o'clock automatically. But because of it has
some sensitive information (login name and passwords) I've protect it with standard linux
autoration with user and access limits here is details:</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">user: kohaadmin</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">access: chmod 600 backup_script</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">cron: 8 o'clock at evening</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">--------------------------------------------------------------------------------------------------</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">#!/bin/bash</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"># koha's back-up cron script</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">BACKUP=koha`date +%y%m%d`</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">mysqldump --add-drop-table -uXXX -pXXX Koha >/var/backup/$BACKUP</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">ncftpput -V -u USER -p XXX 160.75.14.95 Koha /var/backup/$BACKUP</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">---------------------------------------------------------------------------------------------------</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">This script is generating a copy of whole koha database in /var/backup directory on a file
named a file initial koha and continued year+moth+day for example: </span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">koha041221</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">koha041222</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">koha041223</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">This means </span></font><font face="Arial"><span style="font-size:10pt">a file for every day. But you can
configure this period as you want.</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Then for a strong backup strategy, script is copying same backup file to another machine
with command ncftpput. But this was an old way now it is more useful and secure to use
scp command as you document.</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Best regards.</span></font></div>
<div align="left"><br/>
</div>
<div align="left"><br/></div>
<div align="left"><br/>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Zeki Celikbas</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Librarian</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Istanbul Technical University         e:</span></font><font face="Arial" color="#008000"><span
style="font-size:10pt"><u>celikbas@itu.edu.tr</u></span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Faculty of Aero. &  Astro.              
w:</span></font><font face="Arial" color="#008000"><span style="font-size:10pt"><u>http://www2.itu.edu.tr/~celikbas</u></span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">34469 Maslak Istanbul Turkey       t:(212)2853108 f: (212)2853139</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~</span></font></div>
</body>
</html>