I want to get rid of all the records in koha, not all the records had accession numbers when they were imported so the batch delete is not effective. Tried truncating the tables in MySql but when I search the OPAC, the records still appear as if nothing was done to remove them. Can anyone assist on how to truly delete all the records from koha? Regards, Davian Cooper
Hey Davian, Your zebra index is probably with the records still indexed, because when you run a query directly in the database, there's nothing telling zebra it needs to remove said records from the index. What happens if you actually select a record from the search? Reindex zebra and check again. GL, Pedro Amorim 2017-05-15 15:43 GMT+00:00 Davian Cooper <davian.cooper@nlj.gov.jm>:
I want to get rid of all the records in koha, not all the records had accession numbers when they were imported so the batch delete is not effective. Tried truncating the tables in MySql but when I search the OPAC, the records still appear as if nothing was done to remove them. Can anyone assist on how to truly delete all the records from koha?
Regards,
Davian Cooper
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Davian
I want to get rid of all the records in koha, not all the records had accession numbers when they were imported so the batch delete is not effective. Tried truncating the tables in MySql but when I search the OPAC, the records still appear as if nothing was done to remove them. Can anyone assist on how to truly delete all the records from koha?
Delete all bibliographic records on the MySQL command line: DELETE FROM issues; DELETE FROM biblio; DELETE FROM biblioitems; DELETE FROM items; Then rebuild the Zebra index for the bibliographic records on the Shell: $ export KOHA_CONF=/etc/koha/sites/YOURINSTANCE/koha-conf.xml $ export PERL5LIB=/usr/share/koha/lib $ sudo koha-rebuild-zebra -b -v YOURINSTANCE You didn't mention authority records, so these will be not touched by this. Hope this helps. Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
Hi Davian Sorry, the following two lines are not necessary when using script "koha-rebuild-zebra" (but they won't hurt either):
$ export KOHA_CONF=/etc/koha/sites/YOURINSTANCE/koha-conf.xml $ export PERL5LIB=/usr/share/koha/lib
So you can just execute the following as your usual Koha user. $ sudo koha-rebuild-zebra -b -v YOURINSTANCE Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E mik@adminkuhn.ch · W www.adminkuhn.ch
participants (3)
-
Davian Cooper -
Michael Kuhn -
Pedro Amorim