Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You should have an up to date copy of the master conditions database locally, now.

Administration

Backing Up the Database

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

Code Block
titleCreating a Backup
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.

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

Code Block
titleLoading a Backup
mysql -h hpsdb.jlab.org -u jeremym -pXXXXXX hps_conditions < hps_conditions.sql

 

The above command is listed for reference only and you should not try to execute it. 

Fully restoring the database from a backup would need to go through a JLAB CCPR, as the accounts we have access to do not have all the proper permissions for doing this.

Configuring Detector Conditions for a Job

...