[Koha] Backing up 3.0

[Doug Dearden]

Thanks for the link, I'll check that out.  Are you backing up the file
system as well?  Any thought to restoring on a different server in the
event of a total system crash?

Doug

>>> "Chadwick, John, DCA" <john.chadwick at state.nm.us> 12/18/2008
11:11:15 AM >>>
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. 



_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz 
http://lists.katipo.co.nz/mailman/listinfo/koha