[Koha] delete content of a biblio instance

[rogan.hamby at gmail.com]

Well, it depends.

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;

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....



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
>