Server version: 5.0.18
TCP port: 3306
- DSN: mysql://gen@yerphi.jlab.org/e02013^
+ DSN: mysql://e02013@jmysql.jlab.org/e02013
pass: IXt4ldk.^
-=Structure=-
- There will be at least two classes of databases; one for direct and fast access to the EPICs information throughout the experiment (being developed by Brandon) and the second to hold calibration constants to be used by the analyzer (being developed by Rob). The description and rough specifications for the databases are here.
+ There will be at least two classes of databases; one for direct and fast access to the EPICs information throughout the experiment (being developed by Brandon) and the second to hold calibration constants to be used by the analyzer (being developed by Rob). The description and rough specifications for the databases are [http:tiki-download_wiki_attachment.php?attId=23&page=GEnDB|here].
-=Backup=-
+
+ WARNING! The information below is outdated and may be inaccurate. The hostname, username, and password have change and this is not reflected below.
+
The database backuped up by user nerses using crontab job run every night from ifarml2. The scipt launched by cron is /work/halla/e02013/disk1/GEn/db/dump_e02013.sh. Back-ups are collected in the same directory (/work/halla/e02013/disk1/GEn/db).
-=Accessing DB=-
There are 2 mysql user accounts for accessing e02013 database:
- {DL()}gen_admin: used to fill the database with data (password protected)
gen: used for read only access of data could be accessed using the following command{CODE()}mysql -h yerphi -u gen{CODE}{DL}
+ {DL()}gen_admin (not sure this exists anymore): used to fill the database with data (password protected)
e02013: used for read only access of data could be accessed using the following command{CODE()}mysql -h jmysql -u e02013 -p{CODE}{DL}with password: IXt4ldk.
| ![[hide]](javascript:icntoggle('mod-mnu_application_menu','mo.png');)
Wiki