Slow Controls Time History: Difference between revisions
No edit summary |
No edit summary |
||
| Line 19: | Line 19: | ||
mysqldump -uroot -pe1tocome epics | gzip > /misc/mysql/clasweb-bck/epics.sql.gz | 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)) | 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)) | ||
Following command produce error message but runs: | |||
mysqldump -f -l --opt -uroot -pe1tocome epics | gzip > /home/epics.sql.gz | |||
mysqldump: Got error: 1016: Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145) when using LOCK TABLES | |||
Revision as of 17:52, 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))
Following command produce error message but runs:
mysqldump -f -l --opt -uroot -pe1tocome epics | gzip > /home/epics.sql.gz mysqldump: Got error: 1016: Can't open file: 'hallb_sf_xy560_0_12_1min.MYI'. (errno: 145) when using LOCK TABLES