[Deploying Sakai] Restoring from a backup

Stephen Marquard stephen.marquard at uct.ac.za
Thu Apr 1 00:51:42 PDT 2010

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.

>>> 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. 
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,




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.


More information about the production mailing list