[Koha] How talk Mysql backup

Nicole Engard nicole.engard at liblime.com
Tue May 5 23:44:53 NZST 2009


Also - it's always good to refer to the manual :)

https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/Appendicies/backing-up-koha

---

Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at 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 at 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 at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list