[Koha] Deleting biblios and items

Bruns, Anke Anke.Bruns at gwdg.de
Wed Nov 8 00:03:28 NZDT 2023


your_koha_library in this case means the database name. This is typically "koha_<instancename>". If you open MySQL (before the "use" step), you can list your database(s) with "show databases;" to see the exact name.

When everything is done, don't forget to set the Foreign Key check back to 1.
You can leave MySQL by entering "quit", then the prompt will change back to the one you see when logged in as the linux root user.

I recommend also to create a database dump as a backup before these activities in case anything goes wrong and you want to restore the database.

Best regards,

> -----Urspr√ľngliche Nachricht-----
> Von: Koha <koha-bounces at lists.katipo.co.nz> Im Auftrag von Aida Djikic
> Gesendet: Dienstag, 7. November 2023 10:15
> An: koha at lists.katipo.co.nz
> Betreff: [Koha] Deleting biblios and items
> Hello all,
> I've been looking up how to delete all biblios and items since I made some
> errors and would like to restart with a clean slate without losing my
> settings and customizations.
> I want to check whether the commands listed on
> https://wiki.koha-
> community.org/wiki/How_to_delete_all_records_and_keep_settings
> are to be entered exactly as written, or if there's anything that's assumed
> to be understood by more experienced users. I am really struggling whenever
> I have to use terminal commands.
> E.g. where it says
> Login to database
>   sudo su
>   mysql -u root
>   use your_koha_library;
> Can I assume your_koha_library is where the instance name goes or is this
> literally what should be entered into the terminal? If not the instance
> name, what should be entered?
> How does one log in to mysql and then move back to root once done with
> these changes?
> When only deleting biblios and items, does Zebra index need to be reset for
> both biblios and authorities, or just the biblios?
> Thank you in advance!
> --
> Regards,
> Aida
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list