Versions Compared

Key

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

...

You will need to be logged into a JLAB machine like jlabl3 for this step, and you must also have a MySQL account with the correct privileges. 

No Format
mysqldump -h jmysqlhpsdb.jlab.org -ujeremym -pXXXXXXXX --disable-lock-tables hps_conditions &> jlab_conditions_db.sql

...

In general, you should prefer not to make a alterations or additions to the local database.  These procedures are instead designed for running reconstruction and analysis without an internet connection on your local machine.  Any official changes to be used in production, such as recon passes run at JLAB, must be made on the JLAB database through the HPS database administrators or other users with the correct privileges.  In order for others to use any conditions you might like to add to the system, the best approach will be adding that information to the primary database and then replicating it to the public SLAC database, rather than having others connect directly to your database instance.