Transfer your Old Koha Database to Newly Installed Koha

The following procedure must be followed carefully while transferring your old koha database to your Newly installed Koha.

Step 1: Backup of your Old Koha Database:
Use following command while taking backup of your existing koha Database:

mysqldump -uroot -p koha_library | gzip -9 > koha_library.sql.gz  
Step 2: Install Koha in your new System:
Use following link for fresh Koha installation:
https://listechsavvy.blogspot.in/2016/11/installation-koha-on-ubuntu-1404.html

Step 3: Remove Koha Database from your newly installed Koha System:
Use following command to remove existing koha database: 
(i) sudo su

(ii) mysql -uroot -p 

      (Enter the MySQL Root password) 
(iii) drop database koha_library;
(iv) create database koha_library;
(v) quit;

Step 4: Restoration of Old Koha Database in your new System:

Use the following command for the restoration of old database backup in your new system:

mysql -uroot -p koha_library < koha_library.sql     

(Check name of your source Koha database)

Enter the MySQL root password.

Step 5: Upgrade Database Schema:
Use the following command for upgrading your database schema in your new system:

sudo su
koha-upgrade-schema library

Step 6: Rebuild the Zebra Index:
Use the following command in your terminal:

sudo koha-rebuild-zebra -v -f library