[Building Sakai] Archiving Sakai Events & Sessions in Sakai 2.7.x

[Paul Dagnall]

Mike
Michigan does have a great process for this.

What we do is periodically take all events and session records that are more
than 3 months old and remove them from the db, and store them externally as
a file. The files are dated so if for some reason we need to query those, we
can grab the date range we need.

Paul Dagnall
Application Developer & Administrator
University of Dayton


On Tue, Oct 18, 2011 at 1:43 PM, Mike Jennings <mike_jennings at unc.edu>wrote:

> I was just going to bump this back to the list as any help would be
> greatly appreciated.
>
> Mike
>
> -------- Original Message --------
> Subject: [Building Sakai] Archiving Sakai Events & Sessions in Sakai 2.7.x
> Date: Mon, 17 Oct 2011 15:02:32 -0400
> From: Mike Jennings <mike_jennings at unc.edu>
> Reply-To: <mike_jennings at unc.edu>
> Organization: UNC-Chapel Hill
> To: <sakai-dev at collab.sakaiproject.org>
>
> I am interested to see what peoples recommendations for cleaning up the
> Sakai Events & Sessions tables are in Sakai 2.7.x with a MySQL Database.
>
> I have found the following information from the University of Michigan
> where they have a great document describing the Managing of Session and
> Event Archives in there environment.
>
> https://jira.sakaiproject.org/browse/PROD-2
>
> I was wondering if there are some best practices for getting this done,
> or some standard sakai scripts out there for achieving this.
>
> Thanks,
>
> Mike Jennings
> --
>
> ==============================================================================
> Mike Jennings
> Teaching and Learning Developer
> University of North Carolina at Chapel Hill
>
> Office: (919) 843-5013
> Cell: (919) 442-8337
> E-mail: mike_jennings at unc.edu
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20111018/59d208db/attachment.html