database:database
This is an old revision of the document!
Table of Contents
Databases
How to make a snapshot of the online database
On lxplus, do:
SetupProject LHCb --dev --use-grid lhcb-proxy-init
Now create a folder where your database should be, like ~/mydatabase. Set this path to $SQLITEDBPATH
Then do:
CondDBAdmin_MakeSnapshot.py --options $SQLDDDBROOT/options/SQLDDDB-Oracle.py -s 2010-02-01UTC -u yyyy-mm-ddUTC ONLINE sqlite_file:myFileName.db/ONLINE
where yyyy-mm-dd is the date in year-month-day which it should cover.
How to access the database in the options file
Do
from Configurables import CondDB, CondDBAccessSvc
CondDB(UseOracle = False)
connection="sqlite_file:/afs/cern.ch/user/initial/name/mydatabase/myFileName.db/ONLINE"
CondDB().addLayer(CondDBAccessSvc("DB",ConnectionString=connection))
database/database.1273680908.txt.gz · Last modified: 2010/05/12 18:15 by nchiap
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
