Tanzeem,

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 biblionumber=100);
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.

Nicole

On Wed, Nov 23, 2011 at 1:49 AM, tanzeem <tanzeem.mb@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@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha