[Koha] delete content of a biblio instance

Heinz-Jürgen Oertel hj.oertel at t-online.de
Wed Jul 8 05:31:56 NZST 2020


Am Dienstag, 7. Juli 2020, 17:55:20 CEST schrieb rogan.hamby at gmail.com:
> Well, it depends.

to your first question. It is not a used running system yet. I just used it to 
get familiar with it. The first import in a new biblio was not successful, not 
the correct import data used. Now I like to empty it and import a new export 
from another system.

> If you only have bibs and items loaded this should work:
> 
> SET FOREIGN_KEY_CHECKS = 0;
> truncate biblio;
> truncate biblioitems;
> 
> truncate items;
> truncate auth_header;
> truncate sessions;
> truncate zebraqueue;
> truncate biblio_metadata;
> SET FOREIGN_KEY_CHECKS = 1;

I assume that are all data base commands to the biblio data base?

> However, if you've had this as a living system with transactions you will
> also need to look at cleaning out a lot of other tables such as statistics,
> issues, etc....

see above.

Thanks and Greetings
    Heinz

> 
> 
> On Tue, Jul 7, 2020 at 11:17 AM Luis Moises Rojas <lmoisesrojas at gmail.com>
> 
> wrote:
> > Hi,
> > That was my question a few days ago, and there is no way.
> > 
> > I don't know if there is any answer now
> > 
> > El mar., 7 de jul. de 2020 9:40 AM, Heinz-Jürgen Oertel <
> > 
> > hj.oertel at t-online.de> escribió:
> > > Hello
> > > 
> > > I'm looking for a way to delete the complete content of a biblio
> > 
> > instance,
> > 
> > > not
> > > the instance itself in order to keep "Item types", "Patron categories"
> > 
> > etc.
> > 
> > > Any hint is very welcome. After deleting the content,, I want to import
> > > new
> > > data via marcxml import.
> > > 
> > > Greetings
> > > 
> > >         Heinz
> > > 
> > > _______________________________________________
> > > 
> > > Koha mailing list  http://koha-community.org
> > > Koha at lists.katipo.co.nz
> > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> > 
> > _______________________________________________
> > 
> > Koha mailing list  http://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


-- 
mit freundlichen Grüßen aus Halle (Saale)
       Heinz-Jürgen Oertel




More information about the Koha mailing list