[Koha] Deleting biblios and items

Thu Nov 9 22:03:21 NZDT 2023

Hi Aida,

this seems strange to me. Unfortunately I don’t have time right now to dig deeper into this. Maybe someone else could help?

Did you truncate zebraqueue? No idea if this is relevant to the problem though.

Best regards,

Anke

-- 

Anke Bruns M.A. (LIS)

Arbeitsgruppe "Anwendungs- und Informationssysteme"

E-Mail:  <mailto:anke.bruns at gwdg.de> anke.bruns at gwdg.de

-------------------------------------------------

Gesellschaft für wissenschaftliche Datenverarbeitung mbH Göttingen (GWDG)

Burckhardtweg 4, 37077 Göttingen, URL:  <https://gwdg.de/> https://gwdg.de

Support: Tel.: +49 551 39-30000, URL:  <https://gwdg.de/support> https://gwdg.de/support

Sekretariat: Tel.: +49 551 39-30001, E-Mail: gwdg at gwdg.de 

Geschäftsführer: Prof. Dr. Ramin Yahyapour

Aufsichtsratsvorsitzender: Prof. Dr. Christian Griesinger

Sitz der Gesellschaft: Göttingen

Registergericht: Göttingen, Handelsregister-Nr. B 598

-------------------------------------------------

Zertifiziert nach ISO 9001 und ISO 27001

-------------------------------------------------

Von: Aida Djikic <aidadjikic at gmail.com> 
Gesendet: Donnerstag, 9. November 2023 09:59
An: Bruns, Anke <Anke.Bruns at gwdg.de>
Cc: koha at lists.katipo.co.nz
Betreff: Re: [Koha] Deleting biblios and items

Hello Anke, 

yes, I had to go back and rebuild it because I forgot to do it the first time. I used 

sudo koha-rebuild-zebra -f -v instancename 

but they are still there: when I go to Authorities > Search main heading, I get a list of 580 entries. Some of them are personal names, some are topical terms though none of them are marked as such, only as Default. I'm not sure why they weren't removed. 

On Thu, Nov 9, 2023 at 9:45 AM Bruns, Anke <Anke.Bruns at gwdg.de <mailto:Anke.Bruns at gwdg.de> > wrote:

Hi Aida,

good to know that it worked well. As to the autorities, if you also truncated the auth_header table they should be gone. What you see might be the Zebra index entries – did you rebuild the Zebra index (or if you use ElasticSearch, I suppose the index has to be rebuilt as well after deleting the records).

Best regards,

Anke

Von: Aida Djikic <aidadjikic at gmail.com <mailto:aidadjikic at gmail.com> > 
Gesendet: Mittwoch, 8. November 2023 12:07
An: Bruns, Anke <Anke.Bruns at gwdg.de <mailto:Anke.Bruns at gwdg.de> >
Cc: koha at lists.katipo.co.nz <mailto:koha at lists.katipo.co.nz> 
Betreff: Re: [Koha] Deleting biblios and items

Hello Anke, 

thank you for the directions; I have followed them and have managed to remove all records. When I run an authority search, I get a list of all of them, though they are now lacking a heading type (it is now marked as "Default"). Is it possible to bulk remove all of them from search results as well or will I need to delete them one by one? 

The ones that were not attached to records have a Delete option, but the few that were have only an Edit option which leads to a "The authority record you requested does not exist" note. 

(Must also remember to uncheck AutoCreateAuthorities as that caused me to have multiple copies of authorities (e.g. thesis advisors, as well as subjects and index terms). Lesson learned the hard way!)

On Tue, Nov 7, 2023 at 12:03 PM Bruns, Anke <Anke.Bruns at gwdg.de <mailto:Anke.Bruns at gwdg.de> > wrote:

Hi,

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,
Anke

> -----Ursprüngliche Nachricht-----
> Von: Koha <koha-bounces at lists.katipo.co.nz <mailto: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 <mailto: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 <http://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 <mailto:Koha at lists.katipo.co.nz> 
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

-- 

Regards,
Aida

-- 

Regards,
Aida