Re: [Koha] Restoration of old Koha database to new one
I used this Tutorial 1. Backup of old Koha Take 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 backup, mysqldump -uroot -p koha_library | gzip -9 > koha_library.sql.gz Put MySQL root password, when it ask. 2. Install Koha 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 [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. 4. 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 5. Rebuild the Zebra Index. Apply following command in a terminal, sudo koha-rebuild-zebra -v -f library 2018-02-12 6:35 GMT-06:00 Bob Birchall: > After installing the old database, log in to the staff client. You should > get the 'web installer', not the Home page. Koha will detect that the DB > needs to be upgraded and will do so. > That's a pretty big upgrade. When its done, a lot of your reports might > need repair. If so, you'll get a warning on your 'saved reports' page. > Also examine the About page System Information tab and note any warnings. > HTH, > Bob Birchall > Calyx > > > On 12/02/18 23:16, Igbudu Tersoo wrote: > >> Hi, >> I have installed koha 17.11 successfully. i am trying to restore data from >> an old version (Koha 3.18) . after dropping the new database and restoring >> the old one. i tried to upgrade the database schema using >> >> *koha-upgrade-schema library, then it gives this error on command >> line:*Use >> of uninitialized value in numeric lt (<) at >> /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl >> line 5531. >> Failed to add reserve_id to reserves tables, please refresh the page to >> try >> again. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ >> updatedatabase.pl line 5591. >> >> please what can i do? >> Thanks. >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Restoration of old Koha database to new one
After installing the old database, log in to the staff client. You should get the 'web installer', not the Home page. Koha will detect that the DB needs to be upgraded and will do so. That's a pretty big upgrade. When its done, a lot of your reports might need repair. If so, you'll get a warning on your 'saved reports' page. Also examine the About page System Information tab and note any warnings. HTH, Bob Birchall Calyx On 12/02/18 23:16, Igbudu Tersoo wrote: Hi, I have installed koha 17.11 successfully. i am trying to restore data from an old version (Koha 3.18) . after dropping the new database and restoring the old one. i tried to upgrade the database schema using *koha-upgrade-schema library, then it gives this error on command line:*Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5531. Failed to add reserve_id to reserves tables, please refresh the page to try again. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ updatedatabase.pl line 5591. please what can i do? Thanks. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Fwd: Restoration of old Koha database to new one
-- Forwarded message -- From: Igbudu TersooDate: Mon, Feb 12, 2018 at 12:16 PM Subject: Restoration of old Koha database to new one To: koha@lists.katipo.co.nz Hi, I have installed koha 17.11 successfully. i am trying to restore data from an old version (Koha 3.18) . after dropping the new database and restoring the old one. i tried to upgrade the database schema using *koha-upgrade-schema library, then it gives this error on command line:*Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi- bin/installer/data/mysql/updatedatabase.pl line 5531. Failed to add reserve_id to reserves tables, please refresh the page to try again. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updat edatabase.pl line 5591. please what can i do? Thanks. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Restoration of old Koha database to new one
Hi, I have installed koha 17.11 successfully. i am trying to restore data from an old version (Koha 3.18) . after dropping the new database and restoring the old one. i tried to upgrade the database schema using *koha-upgrade-schema library, then it gives this error on command line:*Use of uninitialized value in numeric lt (<) at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 5531. Failed to add reserve_id to reserves tables, please refresh the page to try again. at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/ updatedatabase.pl line 5591. please what can i do? Thanks. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Z39.50 authority server anyone?
Well, you all are welcome! :-( Anyway, I found the way of doing it. I'm sure there's a neater way, but this one seems to work. Add this line to /etc/koha/sites/"your library"/koha-conf.xml: tcp:@:1 You may use any free port. Then add the following section. You may need to tweak it a bit: /var/lib/koha/biblioteko/authorities /etc/koha/sites/biblioteko/zebra-authorities-dom.cfg /etc/koha/zebradb/pqf.properties http://www.w3.org/2001/XInclude;> http://www.w3.org/2001/XInclude;> http://explain.z3950.org/dtd/2.0/;> __ZEBRA_SRU_HOST__ __ZEBRA_SRU_BIBLIOS_PORT__ authorities /etc/koha/zebradb/ccl.properties As usual, restart the Zebra server or the entire machine. Rubén Fernández Asensio El dissabte, 10 de febrer de 2018, a les 21:48:13 CET, vau escriure: > Hello, I'm trying to set up my Koha as a Z39.50 server. So far I can serve > biblio data, but can't serve authorities. > Has anybody achieved a working configuration? > > This is what yaz-client reports: > yaz-client tcp:biblioteko.esperanto.cat: > Connecting...OK. > Sent initrequest. > Connection accepted by v3 target. > ID : 81 > Name : Zebra Information Server/GFS/YAZ > Version: 4.2.30 98864b44c654645bc16b2c54f822dc2e45a93031 > Options: search present delSet triggerResourceCtrl scan sort > extendedServices namedResultSets > Elapsed: 0.360845 > Z> base biblios > Z> find Zamenhof > Sent searchRequest. > Received SearchResponse. > Search was a success. > Number of hits: 509, setno 1 > SearchResult-1: term=Zamenhof cnt=509 > records returned: 0 > Elapsed: 0.066083 > Z> base authorities > Z> find Zamenhof > Sent searchRequest. > Received SearchResponse. > Search was a bloomin' failure. > Number of hits: 0, setno 2 > Result Set Status: none > records returned: 0 > Diagnostic message(s) from database: > [109] Database unavailable -- v2 addinfo 'authorities' > Elapsed: 0.054520 > > So, the biblio database is served, but the authority database is > unavailable. > > To activate the server, I uncommented all the relevant parts of the file > /etc/ koha/sites/esperanto/koha-conf.xml: > > > > tcp:@: > > However, if you uncomment that aforementioned section, you see it only > relates to bibliographic records: > > > > > > /var/lib/koha/esperanto/biblios > /etc/koha/sites/esperanto/zebra-biblios-dom.cfg > /etc/koha/zebradb/pqf.properties > > xmlns:xi="http://www.w3.org/2001/XInclude;> > > > > > > > identifier="info:srw/schema/1/marcxml-v1.1"> > > inputcharset="utf-8"/> > > > > > inputcharset="utf-8"/> > > > > > > inputcharset="utf-8"/> > > > > > > inputcharset="utf-8"/> > > > > > > inputcharset="utf-8"/> > > > > > > inputcharset="utf-8"/> > > > > > > > > xmlns:xi="http://www.w3.org/2001/XInclude;> > > http://explain.z3950.org/dtd/2.0/;> > > __ZEBRA_SRU_HOST__ > __ZEBRA_SRU_BIBLIOS_PORT__ > biblios > > > > > > > /etc/koha/zebradb/ccl.properties > Carles > Puigdemont > > > So, do I need a similar 'server' and 'serverinfo' section for authorities? > In that case, should I also create a 'listen' entry with a different port? > What's your configuration? Has anybody got an authority server running? > > Rubén Fernández ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha