Difference between revisions of "Backing up and restoring LabTrove"

From LabTrove Documentation
Jump to: navigation, search
(Updated question about large file threshold)
m (4 revisions imported)
 
(2 intermediate revisions by 2 users not shown)
Line 3: Line 3:
 
Version 2.2 of LabTrove stores data items as binary large objects in the MySQL database, subject to a threshold that is configurable by the system administrator. Above the threshold, LabTrove stores large data items in the file system. Storing all but very large files in the database has the advantage that a backup of the database contains all the data in the {{LabTrove Instance}}; restoring that backup with a fresh copy of the code rebuilds the entire {{LabTrove Instance}}.  
 
Version 2.2 of LabTrove stores data items as binary large objects in the MySQL database, subject to a threshold that is configurable by the system administrator. Above the threshold, LabTrove stores large data items in the file system. Storing all but very large files in the database has the advantage that a backup of the database contains all the data in the {{LabTrove Instance}}; restoring that backup with a fresh copy of the code rebuilds the entire {{LabTrove Instance}}.  
  
'''Question for Andy:''' ''My version of LabTrove has nothing related to large files in either <tt>default_config.php</tt> or <tt>config.php</tt>. As you seemed concerned on Wednesday about the threshold setting as it was then, I think it's better if you send me the relevant snippet(s) from your <tt>default_config.php</tt>. I'm happy to deal with the words and formatting.''
+
To view the threshold setting for your {{LabTrove Instance}}, navigate to the <tt>lib</tt> directory and open <tt>default_config.php</tt>. The threshold size above which LabTrove stores large data items in the file system is set in the following line:
 +
<pre>$ct_config['uploads_max_size'] = 1024 * 1024 * 1024 ; // 1Gb</pre>
  
 
For data items stored in the database, use the standard backup and restore procedures, such as those provided by MySQL.
 
For data items stored in the database, use the standard backup and restore procedures, such as those provided by MySQL.

Latest revision as of 17:07, 31 July 2017

How LabTrove stores data items

Version 2.2 of LabTrove stores data items as binary large objects in the MySQL database, subject to a threshold that is configurable by the system administrator. Above the threshold, LabTrove stores large data items in the file system. Storing all but very large files in the database has the advantage that a backup of the database contains all the data in the Trove; restoring that backup with a fresh copy of the code rebuilds the entire Trove.

To view the threshold setting for your Trove, navigate to the lib directory and open default_config.php. The threshold size above which LabTrove stores large data items in the file system is set in the following line:

$ct_config['uploads_max_size'] = 1024 * 1024 * 1024 ; // 1Gb

For data items stored in the database, use the standard backup and restore procedures, such as those provided by MySQL.

For data items stored in the local filesystem, use the backup and restore procedures provided by your institution.