Backing up and restoring QueueMetrics

2012-01-02
To make a backup of a working QueueMetrics system, you should backup the following items:

  • The QM database by typing:

    mysqldump -uqueuemetrics -pjavadude queuemetrics > database.sql

    File will be located at /root/database.sql

  • The web.xml and configuration.properties files being used (You can find them under the QM webapp under WEB-INF; if you run a recent version of QM, just look for the System path entry on the Licence page)

    Files will be located (e.g.) at /usr/local/queuemetrics/webapps/queuemetrics-1.7.0.2/WEB-INF/

  • The queue_log data used for input (it is advisable to this in any case, even if you use MySQL storage, just to be on the safe side).

    Files will be located: /var/log/asterisk

Restoring:

  • Create an appropriately named database on the target machine and make it accessible to user 'queuemetrics' password 'javadude'
  • Load the file using the mysql command:

    mysql -uqueuemetrics -pjavadude queuemetrics < database.sql

  • Restore web.xml, tpf.properties and configuration.properties under the WEB-INF directory of the new QM instance
  • Then open up GUI window where QueueMetrics is located (e.g. http://127.0.0.1:8080/queuemetrics ) and run the DB updater wizard to repair.