[Koha] SQL queries to delete records from the database?

[Sonia P.]

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 at 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 at hotmail.com
> CC: koha at lists.katipo.co.nz
> 
> On 23 July 2012 15:57, Sonia P. <sossolapro at 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