Backing up

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

  If you receive an error that says "mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces" just add the option --no-tablespaces to your mysqldump command - this option was added to MySQL 5.7.31 and MySQL 8.0.21 and later.

• 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-$VERSION/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.