[Deploying Sakai] Restoring from a backup

[leonardo jr escorido]

Thanks Stephen for looking in and the suggestion.


I investigated it further and found out that Sakai has 2 options storing uploaded files: in the db(default), in the file system(setting the bodyPath at org.sakaiproject.content.api.ContentHostingService property).

The Sakai instance where I backed up the db from uses Option 2, while I restored the db for my local Sakai instance (using the default sakai.properties) that uses Option 1. So there goes the cause, next will be finding/doing the solution. I am still soliciting any advice from anyone who have done or knowledgeable on this.

Regards,
Leo


--- On Thu, 4/1/10, Stephen Marquard <stephen.marquard at uct.ac.za> wrote:

From: Stephen Marquard <stephen.marquard at uct.ac.za>
Subject: Re: [Deploying Sakai] Restoring from a backup
To: production at collab.sakaiproject.org, "leonardo jr escorido" <escorido at yahoo.com>
Date: Thursday, April 1, 2010, 12:51 AM

We recently changed our backup script config to include --hex-blob e.g.

/usr/bin/mysqldump --verbose --hex-blob --max-allowed-packet=64M --debug-info --quick --single-transaction 

May be relevant.
 
Cheers
Stephen

>>> leonardo jr escorido <escorido at yahoo.com> 4/1/2010 5:45 AM >>> 


I am beginning to think that this is more of a db issue than a Sakai, but still posting it here hoping someone had successfully restored Sakai data from a backup and will share how they managed to do this.

I backup a db (using Sakai 2.5 schema), restored it in a new db. There were no errors when restoring, then ran the migration scripts to Sakai 2.6 schema. I am able to use the data from the backup, except for those data stored as blob type, like resources/files uploaded to Sakai. 
ex. 
When clicking on the images already uploaded, it is not rendered. 
After downloading document files from the application, the files cannot be opened.

I believe this has been done successfully. I will appreciate it very much any advice.


Thanks a lot,
Leo







      



 
______________________________________________________________________________________________ 

UNIVERSITY OF CAPE TOWN 

This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 4500. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.

_____________________________________________________________________________________________________
 



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/production/attachments/20100401/f085dbef/attachment.html