How to backup settings of users in GUI

Backup

Recommended way

OBSOLETE!! Use How_to_backup_settings_of_users_and_data_of_GUI_by_cron

Use backup/restore functions in the GUI.

Run in bash following commands to dump only configuration (users/alerts etc. - does not includes CDRs,registers,messages)

mydb='voipmonitor'; mysql ${mydb} -Ne "show tables from voipmonitor where \
  \`Tables_in_${mydb}\` LIKE '%\_\_%' OR \
  \`Tables_in_${mydb}\` LIKE 'alerts_%' OR \
  \`Tables_in_${mydb}\` LIKE 'audit_log' OR \
  \`Tables_in_${mydb}\` LIKE 'cdr%' AND \
  \`Tables_in_${mydb}\` NOT LIKE 'cdr_custom_headers' OR \
  \`Tables_in_${mydb}\` LIKE '%country%' OR \
  \`Tables_in_${mydb}\` LIKE 'chart_cache' OR \
  \`Tables_in_${mydb}\` LIKE 'file_cache' OR \
  \`Tables_in_${mydb}\` LIKE 'billing_agregation%' OR \
  \`Tables_in_${mydb}\` LIKE 'daily_reports_sended' OR \
  \`Tables_in_${mydb}\` LIKE 'geoip%' OR \
  \`Tables_in_${mydb}\` LIKE 'livepacket%' OR \
  \`Tables_in_${mydb}\` LIKE 'register%' OR \
  \`Tables_in_${mydb}\` LIKE 'tracker_%' OR \
  \`Tables_in_${mydb}\` LIKE 'cache_number_location' OR \
  \`Tables_in_${mydb}\` LIKE 'contenttype' OR \
  \`Tables_in_${mydb}\` LIKE 'files' OR \
  \`Tables_in_${mydb}\` LIKE 'fraud_alert_info' OR \
  \`Tables_in_${mydb}\` LIKE 'hostname_cache' OR \
  \`Tables_in_${mydb}\` LIKE 'message' OR \
  \`Tables_in_${mydb}\` LIKE 'rtp_stat' OR \
  \`Tables_in_${mydb}\` LIKE 'system' \
  "| sed -e "s/^/--ignore-table=${mydb}./" |xargs mysqldump -c --skip-triggers --skip-add-locks --skip-disable-keys --skip-add-drop-table --no-create-info ${mydb} > /tmp/settings.sql

Because structure of `users` table varies, dump this table with create statement:

mysqldump voipmonitor users > /tmp/users-create.sql

Restore

If you wish to restore dumpfile, start with a new db:

mysqladmin create voipmonitor

Let your latest sensor create tables needed for voipmonitor service:

/etc/init.d/voipmonitor restart

Let your GUI create tables needed for GUI, Just login to web GUI with your browser (If you are already logged in, logout first and then 're-login'. (default login is admin / admin)

http://voipmonitor_IP

Restore 'users' table structure

mysql voipmonitor < /tmp/users-create.sql

Restore rest

mysql voipmonitor < /tmp/settings.sql