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 m...@adminkuhn.ch · W www.adminkuhn.ch _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
