You can make backups of License Statistics host and/or database as described below.

Backing up the License Statistics host

If you are running License Statistics in a virtual environment, we recommend backing up the entire virtual machine (and database VM if it is external). To perform the backup, follow the instructions for the virtual environment of your choice and the policy used in your organization.

Backing up the License Statistics database

To make a backup of the License Statistics database, use one of the methods described below.

Use the xflicstat-cli utility

You can use the xflicstat-cli utility to perform a database backup, as described in the following sections.

Using the License Statistics CLI

Backing up and restoring an embedded database

For scheduled backups, consider using the optional "--allow-live-backup" flag to allow backups to be performed without stopping License Statistics.

Use the mysqldump utility

To back up the License Statistics database using the mysqldump utility:

  1. Run the mysqldump utility (paths shown are default paths; revise the path if needed for your installation):
    - For Windows: C:\Program Files\X-Formation\License Statistics\mysql\mysqldump.exe
    - For Linux: /opt/xflicstat/embedded/bin/mysqldump
  2. Enter the following command:
    mysqldump --single-transaction -h<host> -P<port> -u<user> -p<password> <database> > licstat.sql

For example, the command for backing up an embedded database is:

mysqldump --single-transaction -uroot xformation_licstat > licstat.sql