Search/Navigation:
Related:
SLAC/EPP/HPS Public
Jefferson Lab/Hall B/HPS Run Wiki
S30XL-LESA/LDMX
...
Code Block | ||
---|---|---|
| ||
java -Dorg.hps.conditions.url=jdbc:mysql://mysql-node03.slac.stanford.edu:3306/rd_hps_cond \ -Dorg.hps.conditions.user=rd_hps_cond_ro \ -Dorg.hps.conditions.password=2jumpinphotons. [...] |
This database is updated only periodically, not automatically, so you may need to check if it is up-to-date before using it for your jobs.
...
Code Block | ||
---|---|---|
| ||
https://github.com/JeffersonLab/hps-conditions-backup/raw/master/hps_conditions.db.tar.gz tar -zxvf hps_conditions.db.tar.gz |
This file may not be up to date with the current master in the JLab conditions database!
The local db file can be used by using this option when running Java:
...
No username or password is required when connecting locally in this way.This file may or may not be up to date with the current master in the JLab conditions database!
Warning |
---|
The |
Creating a Local SQLite Database
In order to create a local SQLite database, you will need to create a snapshot of the MySQL database and then convert it to a SQLite db file.
...
Code Block | ||
---|---|---|
| ||
mysqldump --skip-extended-insert --compact -u hpsuser --password=darkphoton -h hpsdb.jlab.org --extended-insert=false --lock-tables=false hps_conditions > hps_conditions.mysql |
...
Code Block | ||
---|---|---|
| ||
mysqldump -h hpsdb.jlab.org -ujeremymu$USER -pXXXXXXp$PASSWORD hps_conditions &> hps_conditions.sql |
... where 'jeremym' $USER
is replaced by your account name (that has with the proper permissions ) and 'XXXXXX' $PASSWORD
with your password.
...
Code Block | ||
---|---|---|
| ||
mysql -h hpsdb.jlab.org -u jeremym$USER -pXXXXXXp$PASSWORD hps_conditions < hps_conditions.sql |
...
Code Block |
---|
mysqldump -h hpsdb.jlab.org -uUSERu$USER -pPASSWORDp$PASSWORD --disable-lock-tables hps_conditions &> hps_conditions_for_slac.sql |
...
Code Block |
---|
scp hps_conditions_for_slac.sql USER@rhel6$USER@rhel6-64.slac.stanford.edu:/nfs/slac/g/hps/someDir |
...
Code Block |
---|
mysql -D rd_hps_cond -h mysql-node03.slac.stanford.edu -P 3306 -u USER$USER -p PASSWORD$PASSWORD < /nfs/slac/g/hps/someDir/hps_conditions_for_slac.sql |
...