Page History

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

...

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.