[Koha] How talk Mysql backup

Rick Welykochy rick at praxis.com.au
Sun May 3 22:06:40 NZST 2009


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.


More information about the Koha mailing list