[Koha] Need advice regarding removal of deleted biblio records

Alvaro Cornejo cornejo.alvaro at gmail.com
Wed Jun 26 08:49:47 NZST 2019


Hi

If you do a Marc import through the koha importing tool, you can remove the
records through the same process. You just need to check which import
process you want to remove and that's it.

Regards,

Alvaro
|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
              Visitenos en www.perusms.com


Le mar. 25 juin 2019 à 15:44, Andy Boze <boze.1 at nd.edu> a écrit :

> Dear all,
>
> I'm hoping someone can give me a bit of direction. We have a large
> number of deleted biblio records (due to a failed MARC records import).
> We'd like to remove the deleted records from the database as there are
> somewhat more deleted records (401,000) than active records.
>
> Is there a script than can clean up deleted records? I've seen this
> "Clean up database" script <
>
> https://koha-community.org/manual/18.11/en/html/cron_jobs.html#clean-up-database
>  >, but it's not what we're looking for.
>
> If there's no script, can we safely use the MySQL TRUNCATE command on
> the deletedbiblio, deletedbiblio_metadata, deletedbiblioitems and
> deleteditems tables? This is a non-circulating library, so I don't think
> the biblionumber would be tied to any other tables.
>
> I'll appreciate any guidance. We're using Koha 18.11 and MariaDB 5.5.60.
>
> --
> Andy Boze, Associate Librarian
> University of Notre Dame
> 271H Hesburgh Library
> (574) 631-8708
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


More information about the Koha mailing list