<?xml version="1.0" encoding="utf-8"?>
<html>
<span style="font-size:medium;">
<strong>Applicable Releases:</strong> Up to caArray 2.x
<strong>Date entered:</strong> September 23, 2009
</span>
questionDiv
question
Question: Can I recover a mistakenly deleted experiment from a caArray database backup? questionEnd
A user deleted an experiment that was in "draft" or "in progress" status. His database administrator has the backupe for the entire MySQL database. Is it possible to recover only that experiment instead of the whole MySQL database (recently entered data will be lost if a full roll-back is performed)?
questionDivEnd
<noinclude>
\ width="100%" style="border: solid 1px #A3B1BF; background: #F5FAFF" |
- |
answer}}Answer:{{answerEnd
Since information and data on an experiment are physically stored in many tables in caArray's MySQL database, currently there is no backend script available to recover a particular experiment. Instead, the database administrator would need to first restore the entire database backup and then take advantage of the caArray web interface to recover an experiment.
To selectively retrieve an experiment from the backed up database, please follow steps below:
Have a comment? Please leave your comment in caArray End User Forum
</html>