User`s guide

450
Learning mode - Saving entries
When learning mode is used, the dynamic backup database is stored in RAM. This database
will be lost if the Digi router is power cycled. The database in RAM can be saved to flash to
over-write the dbfile with the one in RAM that includes the learnt entries or it can be saved
to a new file.
To save the dbfile to flash from RAM, use the following command.
sqlsave 0 <filename>
Where <filename> is the name of the destination file.
For example, to save the learnt database entries to a file called backup.csv
sqlsave 0 backup.csv
If there are no learnt entries, this command will not create a file. To view the number to
learnt entries, use the command sql 0 ? and refer to the section headed Learning info.
Learning info.
items learned:0
matched retrievals:0
OK
Configure a TransPort to use a backup database
Once the Digi has been configured to run a SQL csv database locally, this backup csv
database can be used in the event of the main SQL database going offline. The configuration
parameters required are:
Configure the IP address of the SQL server to use.
egroup 0 dbhost "192.168.0.50"
Configure the IP address of the SQL server that will have a backup database. If a socket
connection fails to this IP address, the Digi will use the backup IP address.
ipbu 0 IPaddr "192.168.0.50"
Configure the backup database IP address. eg. the loopback address of the Digi router or an
alternative SQL server, this eaxmple shows the loopback IP address of the Digi router.
ipbu 0 BUIPaddr "127.0.0.1"
Set the amount of time in seconds that the connection to the main SQL server will be
retried.
ipbu 0 retrysec 30
Set the Digi to use the backup IP address if the main database is unavailable.
ipbu 0 donext ON