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

Chris Cormack chris at bigballofwax.co.nz
Mon Jul 23 16:00:21 NZST 2012


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


More information about the Koha mailing list