OK, thanks. Yes, I am 100% sure I want to do this. We have been dealing with that recurrent index problem for months now. I am despaired. I could try anything. :) (and deleting a few lines in the biblio table won't probably crash anything...) I don't know how to restore from a back-up but someone is here to deal with major issues like that, and I could learn. Sonia.
From: chris@bigballofwax.co.nz Date: Mon, 23 Jul 2012 16:00:21 +1200 Subject: Re: [Koha] SQL queries to delete records from the database? To: sossolapro@hotmail.com CC: koha@lists.katipo.co.nz
On 23 July 2012 15:57, Sonia P. <sossolapro@hotmail.com> wrote:
So something like that?
mysqldump -u kohauser -p kohalibrary > savedatabase230712.sql
mysql -u username -p[password]use kohalibrary;DELETE FROM biblio WHERE biblionumber='2315'; (never done mysql things in commandline before...) Cheers, Sonia.
Yes
If you are incredibly sure you want do this, and you are sure you know how to restore from a backup, and no one is using or has used Koha since you made that backup.
Chris