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 <[email protected]> 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 < > [email protected]> 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 > > [email protected] > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ > > Koha mailing list http://koha-community.org > [email protected] > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
