[Koha] how to restore deleted marc record/items

Nicole Engard nengard at gmail.com
Sun Nov 27 09:28:43 NZDT 2011


You'll need to know the biblionumbers you want to restore. And then you
need to move them out of the deleted tables and in to the original tables.
So if you want to restore biblionumber 100 you'd do something like this:

insert into biblio (select * from deletedbiblio where biblionumber=100);
delete from deletedbiblio where biblionumber=100;
insert in to items (select * from deleteditems where biblionumber=100);
delete from deleteditems where biblionumber=100;
insert in to biblioitems (select * from deletedbiblioitems where
delete from deletedbiblioitems where biblionumber=100;

Of course you want to back up your database before doing anything like
that, but right now there is no way to restore records in the GUI, so you
have to do it in the DB.


On Wed, Nov 23, 2011 at 1:49 AM, tanzeem <tanzeem.mb at gmail.com> wrote:

> Hi
> I want to restore some of the already deleted records
> I am currently tinkering with the koha database tables-
> deletedbiblio,deleteditms,deletedbiblioitems
> Can anyone guide me in the currect path to do the restore properly
> thanks in advance
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/how-to-restore-deleted-marc-record-items-tp5015705p5015705.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111126/9c090f1c/attachment.html>

More information about the Koha mailing list