[Archivesspace_Users_Group] How to delete a populated repository?

[Katherine Collett]

We would also like to delete some old test repositories (and the Lyrasis training repository) — will this script do that, without bothering our current active repository?  And is it still working with the current version of ArchivesSpace?  

When I try to delete the unwanted repositories I get the “repository not empty” error message.

Katherine


Katherine Collett, Archivist 
Hamilton College Archives 
Burke Library 
198 College Hill Road 
Clinton, NY 13323 
askarch at hamilton.edu 
315-859-4471 
www.hamilton.edu/library/library_collections/archives.html 
www.facebook.com/BurkeLibrary 
Hours: M-F 9:00am-12:00 noon and by appointment; contact to ascertain staff availability before visiting. 

On Mar 26, 2015, at 9:35 AM, Chris Fitzpatrick <Chris.Fitzpatrick at lyrasis.org> wrote:

> Hi Mark,
> 
> I wrote this script last summer to do this:
> 
> https://gist.github.com/cfitz/4fefcfa659ef18bfbe6c
> 
> It's ruby and you'll have to have a rest_client and highline gems installed...
> 
> Does that work for you? 
> 
> b,chris. 
> 
> 
> Chris Fitzpatrick | Developer, ArchivesSpace
> Skype: chrisfitzpat  | Phone: 918.236.6048
> http://archivesspace.org/
> 
> ________________________________________
> From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Mark Cyzyk <mcyzyk at jhu.edu>
> Sent: Wednesday, March 25, 2015 9:52 PM
> To: archivesspace_users_group at lyralists.lyrasis.org
> Subject: [Archivesspace_Users_Group] How to delete a populated repository?
> 
> All,
> 
> Does anyone know how to delete a populated repository?  (We
> inadvertently clicked the wrong thing while performing a migration which
> set in stone our previously-pushed-through erroneous recordset.)
> 
> I tried to Delete, but it won't delete a repository if it is populated.
> I tried to simply move that repository, transferring its content into a
> dummy repository for the time being.  No joy.  ("There was an error")
> I reran the ./scripts/setup-database.sh script hoping it might drop each
> table before recreating/reinitializing.  No joy.
> I attempted to Drop tables individually but can't because of foreign key
> constraints.
> 
> The only other thing I can think to do is to drop, then recreate, the
> whole DB schema in MySQL (which, insofar as I don't have root access
> there, I can't do).
> 
> I kind of expected the Delete button would delete the repository --
> including all its content -- and not leave behind any orphans in the
> backend database?
> 
> How can I delete this pesky repository?!
> 
> Advice much appreciated,
> 
> Mark
> 
> --
> 
> <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
> Mark Cyzyk, M.A., M.L.S.
> Scholarly Communication Architect
> User Interface Applications Group
> The Sheridan Libraries
> The Johns Hopkins University
> mcyzyk at jhu.edu
> 
> Verba volant, scripta manent.