Doug --<br><br>Your process sounds pretty good. I would leave out the perl directories or at least treat them separately from your daily data backup. We should differentiate between different kinds of backups:<br><ul><li>
data: mysqldump, the most important part to backup from a production system<br></li><li>application/configuration: koha directories and conf files, including any customization<br></li><li>system: everything else.<br></li>
</ul>The goals of these are different. Data is the most volatile and is exclusively internal to the application. Everybody should backup their data and mysqldump is the plainest way to do it. <br><br>The application itself and configuration shouldn't change between
installations or upgrades. The premise is that if you have the data,
you can rebuild Koha by repeating installation steps on any system and
loading in the data. Backing these up every day when they are expected to be unchanged is overkill. <br><br>For disaster recovery purposes or shorter recovery windows, or where you can't be trusted to complete a second installation, you start getting into the other two types of backups. These are files on the filesystem and not data from a database. Note that the koha directories may be in different places depending on the type of installation performed, so the backup will not necessarily be useful (and could be harmful) if applied on a different system. This makes it hard to script explicit steps that are still generic enough to satisfy everybody. <br>
<br>IMHO, the koha manual shouldn't get involved with anything beyond data backups. The rest is for the sysadmin of a given system to decide. <br><br>--Joe Atzberger<br><br><div class="gmail_quote">On Thu, Dec 18, 2008 at 11:49 AM, Doug Dearden <span dir="ltr"><<a href="mailto:dearden@sarsf.org">dearden@sarsf.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello all,<br>
<br>
I want to check to make sure I am backing up Koha correctly. I looked<br>
at this reference:<br>
<br>
<a href="http://www.kohadocs.org/Backups_and_Restoring.html" target="_blank">http://www.kohadocs.org/Backups_and_Restoring.html</a><br>
<br>
It refers to the file structure for an earlier version. I couldn't<br>
find anything in the doc at<br>
<a href="https://sites.google.com/a/liblime.com/koha-manual/" target="_blank">https://sites.google.com/a/liblime.com/koha-manual/</a> , but maybe I am<br>
missing something there. Here is what I came up with:<br>
<br>
Backup the database using:<br>
<br>
mysqldump --add-drop-table -u<dbusername> -p<dbpassword> koha ><br>
koha.sql<br>
<br>
I am running multiple databases, and am repeating the above for each<br>
unique database name.<br>
<br>
Backup all of the files in /usr/share/koha .<br>
<br>
Backup the extra config files in:<br>
<br>
/etc/koha<br>
/etc/apache2<br>
/etc/mysql/my.cnf<br>
<br>
I am also backing up these as I made changes to them - perhaps unique<br>
to my install:<br>
<br>
/etc/vsftpd.conf<br>
/etc/network<br>
/etc/hosts<br>
<br>
I am using cron to run several scripts that do the above, using tar<br>
-czf to create compressed files and the copying them to a remote<br>
location that also gets backed up to tape every day.<br>
<br>
As I write this, I am thinking I should add /usr/share/perl5 and<br>
/usr/share/perl to the list.<br>
<br>
Is there anything else needed that won't easily install from a Debian<br>
install? My approach on this is to have a backup of all the unique<br>
items needed for Koha, so I can do a clean install of Debian with<br>
Apache2 and MySQL, then restore from the backups and go. As there will<br>
be core items that change depending on the hardware config, I don't<br>
think I can just backup the entire debian file system and transfer it to<br>
a new machine.<br>
<br>
Thanks,<br>
<br>
<br>
<br>
Doug Dearden<br>
Director, Information Technology<br>
School for Advanced Research<br>
(formerly School of American Research)<br>
(505)954-7220<br>
<a href="http://www.sarweb.org" target="_blank">www.sarweb.org</a><br>
_______________________________________________<br>
Koha mailing list<br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</blockquote></div><br>