How to backup settings of users in GUI

From VoIPmonitor.org
Jump to navigation Jump to search

Backup

Recommended way

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 '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 'daily_reports_%' 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

Another way

Not recommended but can be useful other way to backup GUI settings

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
Retrieved from "https://www.voipmonitor.org//doc/index.php?title=How_to_backup_settings_of_users_in_GUI&oldid=1220"