3 May
2009
3 May
'09
1:06 p.m.
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.