We accidently deleted about 100 books a few weeks ago and would like to recover them. We have a list of the barcodes and titles. What would be
I had a similar problem not long ago and discovered that at least on my system the table structure of the deleted tables did not match the structure of their counter parts. The result was that directly inserting from the deleted tables did not match up and data was lost. In other words even though the tables had the same fields they were not in the same order. I was using something I found online. 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; What I did was restored a backup to a test server and created a tables to use to restore from on the live server. Jorge the best way to do this?
Thanks,
Paul Dokken Software Developer SIL PNG Communication and Technology Services Ukarumpa EHP 444 | Papua New Guinea
-- Jorge de Cardenas | Head Systems Administrator 3512 Darrow Road, Stow, OH 44224 330 688-3295, ext 106 | FAX 330 688-0448 | www.smfpl.org | <http://www.facebook.com/SMFPL> <http://twitter.com/smfpl> <http://pinterest.com/smfpl/boards> If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the institution.