Step 1: Create Backup
Execute the bellow commands in the pc were you want to take the backup of koha database
mkdir /koha_backup
cd /koha_backup
Step 2 : Restoration of Preconfigured Database to newly installed PC
Removing pre-existing database
Execute the bellow steps one by one
sudo mysql -uroot -p
it will prompt for a password . Type the mysql root password which you have entered during the mysql installation and press enter
it will take you to the mysql prompt. execute the bellow commands on that prompt
drop database koha_library;
create database koha_library;
quit;
Step 2 : Install Koha
Follow the instructions available in my koha tutorial portal
Step 3 : Restoring old Database to New Server
Create a backup folder in new pc with the name oldbackup
mkdir /oldbackup
Copy the old database from the Old server to new server under the oldbackup directory
Extract the database file
remove the existing koha database from the new server
sudo mysql -uroot -p
drop database koha_library;
create database koha_library;
quit;
database restoration command
cd /oldbackup
ls
the above command will list the items in the folder make sure koha_library.sql file is available in that folder
sudo mysql -uroot -p koha_library < koha_library.sql
Step 4: Database upgrade schema
The database schema of the old Koha version needs to be upgraded to match the new version. Please apply the following commands in a terminal, one by one.
sudo service memcached restart
sudo koha-upgrade-schema library
Step 5: Rebuilding Search Engine Index
sudo koha-rebuild-zebra -v -f library
Now we have completed the koha database upgradation. enjoy new version of koha
