Backing up and restoring QueueMetrics
2012-01-02To 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
- 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.