On Thu 4 Oct, 2018, 1:19 PM Larisa Snabi, <[email protected]> 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 > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
