Tanzeem,<br><br>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:<br>
<br>insert into biblio (select * from deletedbiblio where biblionumber=100);<br>delete from deletedbiblio where biblionumber=100;<br>insert in to items (select * from deleteditems where biblionumber=100);<br>delete from deleteditems where biblionumber=100;<br>
insert in to biblioitems (select * from deletedbiblioitems where biblionumber=100);<br>
delete from deletedbiblioitems where biblionumber=100;<br><br>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.<br>
<br>Nicole<br><br><div class="gmail_quote">On Wed, Nov 23, 2011 at 1:49 AM, tanzeem <span dir="ltr"><<a href="mailto:tanzeem.mb@gmail.com">tanzeem.mb@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi<br>
<br>
I want to restore some of the already deleted records<br>
I am currently tinkering with the koha database tables-<br>
deletedbiblio,deleteditms,deletedbiblioitems<br>
Can anyone guide me in the currect path to do the restore properly<br>
<br>
thanks in advance<br>
<span class="HOEnZb"><font color="#888888"><br>
--<br>
View this message in context: <a href="http://koha.1045719.n5.nabble.com/how-to-restore-deleted-marc-record-items-tp5015705p5015705.html" target="_blank">http://koha.1045719.n5.nabble.com/how-to-restore-deleted-marc-record-items-tp5015705p5015705.html</a><br>
Sent from the Koha-general mailing list archive at Nabble.com.<br>
_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><br>
<a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>
<a href="http://lists.katipo.co.nz/mailman/listinfo/koha" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
</font></span></blockquote></div><br>