 |
Page History
| Scrollbar | ||
|---|---|---|
|
Question: Can I recover a mistakenly deleted experiment from a caArray database backup?
Topic: caArray Usage
Release: <?xml version="1.0" encoding="utf-8"?>
<html>
<span style="font-size:medium;">
<strong>Applicable Releases:</strong> Up to caArray 2.x
<strong>Date Date entered: </strong> September 23, 2009
</span>
caArray Usage
...
Details about the Question
A user deleted an experiment that was in "draft" or "in progress" status. His database administrator has the backupe backup 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
...
Since information and data on an experiment are physically stored in many tables in caArray's MySQL database, currently there is no backend back end 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.
...
- Restore the backed-up MySQL database to another database instance or rename the restored database schema to a different name so that the original database can co-exist with the restored database.
- Install a new caArray instance on another server or VM instance and point this caArray instance to the retored database.
- Add the new caArray application to UPT and assign necessary user privileges to get this new caArray up and running.
- Export the experiment that you wanted to recover from the new caArray instance.
- Upload the experiment into the current caArray application.
Have a comment?
Please leave your comment in the caArray End User Forum</html>.
| Scrollbar | ||
|---|---|---|
|
