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@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@state.nm.us -----Original Message----- From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Doug Dearden Sent: Thursday, December 18, 2008 9:50 AM To: koha@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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha