• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • Whenever you search in PBworks or on the Web, Dokkio Sidebar (from the makers of PBworks) will run the same search in your Drive, Dropbox, OneDrive, Gmail, Slack, and browsed web pages. Now you can find what you're looking for wherever it lives. Try Dokkio Sidebar for free.


How to move your koha database to newly installed Koha

Page history last edited by Vimal Kumar 7 years, 10 months ago

Take backup of your existing Koha database.
Apply the following command in a Applications > Accessories > terminal,

sudo su
mysqldump --single-transaction -u root -p koha > koha.sql

Copy your backup in a pendrive.

Install Koha either using Koha Live DVD / manual installation


Upgrade Koha installation


apt-get update

apt-get upgrade

apt-get install koha-common


Koha Database Restoration process.

Open a terminal and apply following commands.


Remove existing database in new installation


sudo su

mysql -uroot -p

[Enter the MySQL Root password]


drop database koha_library;

create database koha_library;



Copy your database backup from your pen drive to home folder.


Then restore the old backup to new installation.

Database Restoration command,

mysql -uroot -p koha_library < koha_library.sql     [Check name of your source Koha database] 


koha_library - name of database in new installation

koha.sql - name of database in old installation


Enter the MySQL root password.


Upgrade Database Schema

Database schema of old Koha should upgrade to new one. Apply following commands in a terminal,


sudo su

koha-upgrade-schema library


Then rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library

Comments (0)

You don't have permission to comment on this page.