Jeff, Unfortunately, There is significantly more than just the Community table that is effected here. You actually loose the Item, Metadata and Bundle table entries that were present. All that is left is the Bitstream Table with the flag that the Bitstream has been deleted. You would need to restore the database from a backup to recover that database state for not only the Community and Collections objects, but also the Item and Bundle Objects the Bitstreams were attached to.
This is unfortunate news. The only other possibility for recovering the data may be if a third party harvested your OAI gateway and has indexed those dc records, unfortunately, I think such data would also be partial. Sorry the news is not better. Mark On May 28, 2010, at 12:23 PM, Jeffrey W. Pearson wrote: > Thank you for the info so far: The problem with getting technical info > from a user :-( > > > OK. The user did not delete the individual items, he actually deleted > the COMMUNITY. I dont see the data for the record in the community > table. Are we SOL? > > > > Again, thank you all for the suggestions and the user GREATLY > appreciates the efforts to saving his fanny... > > > > Jeff Pearson > USC Libraries > > > > > > > > > > > Peter Dietz wrote: >> I would look in the database table "item". It has a field called >> "item"."in_archive". Typically when an item gets deleted it sets >> item.in_archive to FALSE >> >> So from the DB, you could look for all of the "deleted" items. So use >> your favorite SQL query tool (perhaps pgAdmin3 if your DB is postgres) >> SELECT * FROM item where item.in_archive = false; >> >> >> Or get all the metadata for the deleted items. >> SELECT >> item.item_id, >> item.in_archive, >> metadatafieldregistry.element, >> metadatafieldregistry.qualifier, >> metadatavalue.text_value, >> item.last_modified >> FROM >> public.item, >> public.metadatavalue, >> public.metadatafieldregistry >> WHERE >> item.item_id = metadatavalue.item_id AND >> metadatavalue.metadata_field_id = >> metadatafieldregistry.metadata_field_id AND >> item.in_archive = FALSE >> ORDER BY last_modified DESC; >> >> However, I think deletions to communities and collections make them go >> away, the items may remain behind as an artifact. >> >> >> Peter Dietz >> Systems Developer/Engineer >> Ohio State University Libraries >> >> >> >> On Fri, May 28, 2010 at 2:35 PM, Sands Alden Fish <sa...@mit.edu >> <mailto:sa...@mit.edu>> wrote: >> >> Others should provide some clarification on this, but typically >> deletions are not "hard deletes" but soft, in that there is a >> deletion flag that a cleanup process operates on occasionally. >> Perhaps the database still contains the items, and you can revert >> the deletion by modifying the correct tables? >> >> Sorry that this isn't more detailed. I've never had to dig around >> in that logic before. >> >> -- >> sands fish >> Software Engineer >> MIT Libraries >> Technology Research & Development >> sa...@mit.edu <mailto:sa...@mit.edu> >> E25-131 >> >> >> >> >> On May 28, 2010, at 2:30 PM, Jeffrey W. Pearson wrote: >> >>> Quick question: >>> >>> We had a user delete things he should not have. We have been able to >>> restore the filesystem stuff from backups. Unfortunately, the >>> database >>> backups have been lost. All we really need is the content files. Is >>> there a way to rebuild the content files from just using what is >>> on the >>> file system? >>> >>> Any help would be GREATLY appreciated, especially by the user who >>> deleted the data.... >>> >>> >>> >>> Jeff Pearson >>> USC Libraries >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> _______________________________________________ >>> Dspace-devel mailing list >>> Dspace-devel@lists.sourceforge.net >>> <mailto:Dspace-devel@lists.sourceforge.net> >>> https://lists.sourceforge.net/lists/listinfo/dspace-devel >> >> >> >> ------------------------------------------------------------------------------ >> >> >> _______________________________________________ >> Dspace-devel mailing list >> Dspace-devel@lists.sourceforge.net >> <mailto:Dspace-devel@lists.sourceforge.net> >> https://lists.sourceforge.net/lists/listinfo/dspace-devel >> >> > > ------------------------------------------------------------------------------ > > _______________________________________________ > Dspace-devel mailing list > Dspace-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-devel Mark R. Diggory Head of U.S. Operations - @mire http://www.atmire.com - Institutional Repository Solutions http://www.togather.eu - Before getting together, get t...@ther
------------------------------------------------------------------------------
_______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel
