Deprecated

This page is deprecated. The contents have been moved to the primary Detector Conditions page.

 

The conditions database can be backed up using a command similar to the following:

mysqldump -h hpsdb.jlab.org -ujeremym -pXXXXXX hps_conditions &> hps_conditions.sql

Where 'jeremym' is replaced by your account name and 'XXXXXX' with your password.

This will write the complete set of SQL commands to load the database into the file 'hps_conditions.sql' in the current directory.

To load the database from a backup, the following command would be used.

mysql -h hpsdb.jlab.org -u jeremym -pXXXXXX hps_conditions < hps_conditions.sql

This is listed for reference only and you should not execute this command; restoring from a backup would need to go through a JLAB CCPR as the accounts we have do not have all the proper permissions for reloading the database from scratch to the JLAB MySQL server.

 

  • No labels