[Building Sakai] Recover Deleted Assignment

[Sam Ottenhoff]

>
>
> An instructor accidentally deleted an assignment from their Sakai site. Is
> there a way to recover a deleted assignment?
>

Yes.  Pull a copy of the three ASSIGNMENT_ tables from your database
backup.  Restore them into a separate database.  Then you need to find the
relevant info from the tables.

Find the primary info first:

SELECT ASSIGNMENT_ID FROM ASSIGNMENT_ASSIGNMENT WHERE CONTEXT='THE_SITE_ID'

Then you need to find where the ASSIGNMENT_CONTENT is based on info held in
the XML blob in ASSIGNMENT_ASSIGNMENT.

You can find some basic PHP code to get the restore info here:
https://gist.github.com/ottenhoff/26473811643315f028d1

--Sam
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140408/59194fb5/attachment.html