[Koha] Deleting all records in Koha

Michael Kuhn mik at adminkuhn.ch
Tue May 16 04:13:24 NZST 2017


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 at adminkuhn.ch · W www.adminkuhn.ch


More information about the Koha mailing list