On Thu 4 Oct, 2018, 1:19 PM Larisa Snabi, <larisasnabi@gmail.com> wrote:

Dear Nancy,

We are using the following: OS - Ubuntu 16.04 LTS, Old Koha Version - 3.x The steps we followed were - 1. Installed Ubuntu 2. Installed Koha common which when checked was version 18.05 *3. Restoration of old Koha database to new one* Remove existing database in new 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 new installation.

Database Restoration command,

*mysql -uroot -p koha_library < koha_library.sql *[

*4. Upgrade Database Schema*

*sudo sukoha-upgrade-schema library*

On reaching step 4 the db does not get updated and we get the following error line

*DBD : :mysql: :db do failed: Table 'koha_cpgslibrary.systempreferences' does not exist [for statement "Select " FROM systempreferences WHERE 1=0" ] at usr/share/koha/lib/koha/Database.pm line 110. * Thank you and Regards Larisa