Page History

...

The restricted hpsuser account will be used to run local reconstruction or analysis jobs, but it will not have any privileges to change the database.

If you intend to run the reconstruction offline (or cannot have online access to jlab database on hpsdb.jlab.org), you also need to create the hps_run_db database (v2 is the most updated version), and grant access to it to your mysql user:

mysql> create database hps_run_db_v2;
mysql> GRANT SELECT ON hps_run_db_v2.* TO 'hpsuser'@'localhost';

Creating a Database Dump

You must acquire a SQL dump from the JLAB database which will be loaded locally.

...

If you do not have an account on the JLAB database and do not wish to have one created for you, then you must ask one of the HPS database administrators to create this file for you.

You can also dump the database from your local machine (if you have an internet connection), using the following command:

...

mysqldump --lock-tables=false -h hpsdb.jlab.org -h hpsuser -p hps_run_db_v2 > hps_run_db_v2.sql

beware Beware that this file is huge and the dump operation may require several minutes. 

Loading the SQL File

Next, assuming you have transferred the SQL file to your local computer, you can use the command line tool to load it into a local database.

...