[Koha] Backing up 3.0

[Chadwick, John, DCA]

I am doing something similar. I use a file from sourceforge.net call
AutoMySQLBackup. Very easy to edit and make it executable.

http://sourceforge.net/projects/automysqlbackup

I run backups on a regular basis and have even done a restore from one
box to another with no problems.

John

+-------------------------------------------+
John Chadwick, Ed.D.
Information Technology Manager
New Mexico State Library
1209 Camino Carlos Rey
Santa Fe, NM 87507
505-476-9740
505-476-9761 (FAX)
John.Chadwick at state.nm.us 
 
 
-----Original Message-----
From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of Doug Dearden
Sent: Thursday, December 18, 2008 9:50 AM
To: koha at lists.katipo.co.nz
Subject: [Koha] Backing up 3.0

Hello all,

I want to check to make sure I am backing up Koha correctly.  I looked
at this reference:

http://www.kohadocs.org/Backups_and_Restoring.html 

It refers to the file structure for an earlier version.  I couldn't
find anything in the doc at
https://sites.google.com/a/liblime.com/koha-manual/ , but maybe I am
missing something there.  Here is what I came up with:

Backup the database using:

mysqldump --add-drop-table -u<dbusername> -p<dbpassword> koha >
koha.sql

I am running multiple databases, and am repeating the above for each
unique database name.

Backup all of the files in /usr/share/koha .

Backup the extra config files in:

/etc/koha
/etc/apache2
/etc/mysql/my.cnf

I am also backing up these as I made changes to them - perhaps unique
to my install:

/etc/vsftpd.conf
/etc/network
/etc/hosts 

I am using cron to run several scripts that do the above, using tar
-czf to create compressed files and the copying them to a remote
location that also gets backed up to tape every day.

As I write this, I am thinking I should add /usr/share/perl5 and
/usr/share/perl to the list.

Is there anything else needed that won't easily install from a Debian
install?  My approach on this is to have a backup of all the unique
items needed for Koha, so I can do a clean install of Debian with
Apache2 and MySQL, then restore from the backups and go.  As there will
be core items that change depending on the hardware config, I don't
think I can just backup the entire debian file system and transfer it to
a new machine.

Thanks,



Doug Dearden
Director, Information Technology
School for Advanced Research
(formerly School of American Research)
(505)954-7220
www.sarweb.org
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

______________________________________________________________________
This inbound email has been scanned by the MessageLabs Email Security
System.
______________________________________________________________________


Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.