Also - it's always good to refer to the manual :) https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/Ap... --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce@liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Sun, May 3, 2009 at 6:06 AM, Rick Welykochy <rick@praxis.com.au> wrote:
john smith wrote:
I need to know how to talk a backup and restoration from mysql thnks
To backup the Koha database to a file:
1. mysqldump --opt Koha > backup.sql 2. optionally compress backup.sql to save disk space
To restore the Koha database from a backup:
1. figure out how to delete the existing database 2. mysql -e 'create database Koha' 3. mysql Koha < backup.sql
You better know what your doing with the latter, since you will be destroying whatever was in the database before the restore.
cheers rickw
-- _________________________________ Rick Welykochy || Praxis Services
Finster's Law: A closed mouth gathers no feet. _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha