Koha Backup & Restore

 Koha Backup & Restore

Open Terminal on your Koha System and apply the following command.

sudo apt-get update

1. Remove the existing database and Create the new database in the new Koha installation

Login to SQL  database user

sudo mysql -uroot -p

[Enter your MySQL Root password]

Remove your default database for example koha_library

drop database koha_library;

Create the new existing database (Fro example koha_libpowertech)

create database koha_libpowertech;

quit;

2. Backup Restoration

• Copy your database backup from your pen drive to Koha home folder.
• Extract the backup file, the extension will be .sql
• Then restore the old backup to the new Koha installation.

Database Restoration commands,

sudo mysql -uroot -p koha_lib < koha_library.sql

[Enter your MySQL Root password]

koha_libpowertech - the name of the database in the new installation
koha_library.sql - the name of the database in the old installation

3. Upgrade Database Schema

The database schema of the old Koha should be upgraded to match the new version. 

Apply the following commands in a terminal one by one,

sudo service memcached restart

sudo koha-upgrade-schema lib

[Your Database Name]

4. Rebuild the Zebra Index.

Apply the following command in a terminal,

sudo koha-rebuild-zebra -v -f lib