B&B Electronics R-SeeNet-5 - Manual - Manual (Page 58)

51
5. DATABASE
5. Database
5.1 Description of database
R-SeeNet database consists of five tables. Table Devices contains information about in-
dividual monitoring stations and the last states. In the Day table are kept statistics of each
router in one day. The Stats table contains statistics for each router reading data during one
monitoring cycle. Summary information of a monitoring cycle is stored in the table Summary.
Routers that were unavailable in one monitoring cycle are stored in the table Fails.
5.2 Backing up the database
Database of monitoring system is backed up daily at the hour specified in the installation
process. Backups are stored in the directory with installed R-SeeNet (C:\R-SeeNet\ as stan-
dard). Directory name is in the YYYYMMDD form (year, month, day). Backup from the pre-
vious day is deleted, when a new backup is created. Every first day of month is created a
monthly backup directory in the form YYYYMM, which is held to the first day of next month.
To successfully create a backup monitoring system must contain at least one router.
5.3 Restoring the database
Before restoring the database it is necessary to stop the MySQL service and snmomonsvc
service.
The backup, you want to restore, must be moved to the following directory:
R-SeeNet/mysql/data/snmpmon