When installing a new node, the databases can be loaded manually by working directly with the MySQL client, or they can be 'batch' loaded with the backup files of the required tables from another monitoring host.There are many ways to copy the needed table contents to the new monitoring host. You can 'scp' them, bring up a web browser and download them from there, and I am sure there are many other methods. Here is how I have done it for loading the most recent node that I have installed. Start by logging onto iepm-bw.slac.stanford.edu under the 'iepm' account.
cd /nfs/slac/g/net/iepm-bw/iepm-bw.slac.stanford.edu/mysql-backup scp iepm-bw.slac.stanford.edu.iepm.NODES.yesterday iepm@<full monitoring host name>:/home/iepm scp iepm-bw.slac.stanford.edu.iepm.MONHOSTS.yesterday iepm@<full monitoring host name>:/home/iepm scp iepm-bw.slac.stanford.edu.iepm.NODESPECSyesterday iepm@<full monitoring host name>:/home/iepm scp iepm-bw.slac.stanford.edu.iepm.TOOLSPECS.yesterday iepm@<full monitoring host name>:/home/iepm scp iepm-bw.slac.stanford.edu.iepm.PLOTSPECS.yesterday iepm@<full monitoring host name>:/home/iepm scp iepm-bw.slac.stanford.edu.iepm.GROUPS.yesterday iepm@<full monitoring host name>:/home/iepm scp iepm-bw.slac.stanford.edu.iepm.NODEGROUP.yesterday iepm@<full monitoring host name>:/home/iepm
This is only recommended if you want to replicate the configuration of the main monitoring system. Now load them into the MySQL data base:
cd /home/iepm mysql -u iepm -p < iepm-bw.slac.stanford.edu.iepm.NODES.yesterday mysql -u iepm -p < iepm-bw.slac.stanford.edu.iepm.MONHOST.yesterday mysql -u iepm -p < iepm-bw.slac.stanford.edu.iepm.NODESPECS.yesterday mysql -u iepm -p < iepm-bw.slac.stanford.edu.iepm.GROUPS.yesterday mysql -u iepm -p < iepm-bw.slac.stanford.edu.iepm.NODEGROUP.yesterday mysql -u iepm -p < iepm-bw.slac.stanford.edu.iepm.PLOTSPECS.yesterday mysql -u iepm -p < iepm-bw.slac.stanford.edu.iepm.TOOLSPECS.yesterday
NOTE: NODES must be loaded first
MONHOST must be loded second.