[Deploying Sakai] Restoring from a backup
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,
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.
More information about the production