Slow Controls Time History: Difference between revisions
No edit summary |
No edit summary |
||
Line 14: | Line 14: | ||
Web software runs on clasweb machine. It can be found in /u/group/clas/www/clasweb/htbin/epics_history' directory, in particular file 'db_parms.pm' contains the name of database machine (in our case clondb1) and other related attributes. | Web software runs on clasweb machine. It can be found in /u/group/clas/www/clasweb/htbin/epics_history' directory, in particular file 'db_parms.pm' contains the name of database machine (in our case clondb1) and other related attributes. | ||
DUMPING FROM clasweb-bck: | |||
mysqldump -uroot -pe1tocome epics | gzip > /misc/mysql/clasweb-bck/epics.sql.gz | |||
mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145)) |
Revision as of 17:35, 10 January 2007
Resides in CVSROOT=/home/epics/cvs, normally checked out to /home/epics/history and running on clon01 as user epics.
Main script is:
get_latest_cont.pl
It reads EPICS channels and updates epics database on clondb1.
Cron job is checking if main script is running (if not it will try to restart it):
0,15,30,45 * * * * /home/epics/history/www/check_get.pl
If started by cron job, log file /home/epics/history/log/get_latest_cont.log will be produced.
Web software runs on clasweb machine. It can be found in /u/group/clas/www/clasweb/htbin/epics_history' directory, in particular file 'db_parms.pm' contains the name of database machine (in our case clondb1) and other related attributes.
DUMPING FROM clasweb-bck:
mysqldump -uroot -pe1tocome epics | gzip > /misc/mysql/clasweb-bck/epics.sql.gz mysqldump: Can't get CREATE TABLE for table `hallb_sf_xy560_0_12_1min` (Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145))