How to Upgrade Koha

Open terminal (Ctrl + Alt + t)

sudo apt-get update
sudo apt-get upgrade
sudo apt-get install koha-common

wget -O- http://debian.koha-community.org/koha/gpg.asc | sudo apt-key add -

sudo apt-get clean 

Upgrade Database Schema

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

sudo koha-upgrade-schema library

Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library

Koha Backup and Restore (koha 3.22 to koha 18.11)

Move old Koha database to new installation

1. Backup of old Koha

Take the backup of your existing Koha database. Either you can make use a database kept in your pen drive otherwise you can apply following command to take the backup,

sudo su

mysqldump -uroot -p koha_library | xz > koha_library.sql.xz

Put MySQL root password, when it asks.

2. Install Koha

Follow the instructions in Koha wiki

3. Restoration of old Koha database to a new one

Remove the existing database in the new Koha installation

sudo su

mysql -uroot -p 

[Enter the MySQL Root password]

drop database koha_library;

create database koha_library;

quit;

Copy your database backup from your pen drive to 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 su

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

exit

koha_library - name of database in new installation

koha.sql - name of database in old installation

Enter the MySQL root password.

4. Upgrade Database Schema

Database schema of old Koha should upgrade to match with the new version. Apply following commands in a terminal one by one,

sudo service memcached restart

sudo koha-upgrade-schema library

5. Rebuild the Zebra Index.

Apply following command in a terminal,

sudo koha-rebuild-zebra -v -f library

………………………… END…………………

How to upload local cover book image

> Koha tools

> click on Upload local cover image

> click on browse

> select the file and

> click on upload file

> select image file

> enter cover biblio number

> click on process images

> go to koha administration > global System preferences > Enhanced Content

> Local Cover Images > AllowMultipleCovers [allow]

            > LocalCoverImages [Display]

            > OPACLocalCoverImages [display]

> Save all opac preferences

How to change Koha Opac Header Image (banner)

> Create your banner and

> Login as Root User in Ubuntu

> save it as koha_banner.jpg in /usr/share/koha/opac/htdocs/opac-tmpl/bootstrap/images

> Open Koha and go to System Preferences >OPAC >opacheader >click to edit

> copy the below code and paste it in opacheader area and click on Save all opac preferences.

......................................................................end.......................................................

How to enable root login in linux ubuntu 18.04 in graphical user interface

> go to terminal

> Type: [sudo passwd root] and press enter

> give your existing password and press enter

> type new password for root user

> retype new password for confirmation

> type: [sudo apt update] and press enter

> type: [sudo apt install lightdm]

> type: [cd /etc/lightdm/]

> type: [sudo nano lightdm.conf] when you press enter an editor will open then

> type below commands in the editor:

[SeatDefaults]

greeter-session=unity-greeter

user-session=ubuntu

greeter-show-manual-login=true

> Press ctrl + s to save and then press ctrl + x to close the editor

> type: [sudo reboot]

Root login created