Difference between revisions of "How to backup settings of users in GUI"

From VoIPmonitor.org
Jump to navigation Jump to search
 
(34 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
Run in bash following command to dump only users settings to /tmp/settings.sql
+
= Backup =
 +
== Recommended way ==
  
−
  mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \
+
OBSOLETE!! Use [[How_to_backup_settings_of_users_and_data_of_GUI_by_cron]]
−
  --ignore-table=${mydb}.cache_number_location \
+
 
−
  --ignore-table=${mydb}.cdr \
+
Use backup/restore functions in the GUI.
−
  --ignore-table=${mydb}.cdr_dtmf \
+
 
−
  --ignore-table=${mydb}.cdr_next \
+
Run in bash following commands to dump only configuration (users/alerts etc. - does not includes CDRs,registers,messages)
−
  --ignore-table=${mydb}.cdr_proxy \
+
 
−
  --ignore-table=${mydb}.cdr_reason \
+
 
−
  --ignore-table=${mydb}.cdr_rtp \
+
  mydb='voipmonitor'; mysql ${mydb} -Ne "show tables from voipmonitor where \
−
  --ignore-table=${mydb}.cdr_sip_request \
+
  \`Tables_in_${mydb}\` LIKE '%\_\_%' OR \
−
  --ignore-table=${mydb}.cdr_sip_response \
+
  \`Tables_in_${mydb}\` LIKE 'alerts_%' OR \
−
  --ignore-table=${mydb}.cdr_siphistory \
+
  \`Tables_in_${mydb}\` LIKE 'audit_log' OR \
−
  --ignore-table=${mydb}.cdr_sipresp \
+
  \`Tables_in_${mydb}\` LIKE 'cdr%' AND \
−
  --ignore-table=${mydb}.cdr_tarpart \
+
  \`Tables_in_${mydb}\` NOT LIKE 'cdr_custom_headers' OR \
−
  --ignore-table=${mydb}.cdr_ua \
+
  \`Tables_in_${mydb}\` LIKE '%country%' OR \
−
  --ignore-table=${mydb}.contenttype \
+
  \`Tables_in_${mydb}\` LIKE 'chart_cache' OR \
−
  --ignore-table=${mydb}.files \
+
  \`Tables_in_${mydb}\` LIKE 'file_cache' OR \
−
  --ignore-table=${mydb}.livepacket \
+
  \`Tables_in_${mydb}\` LIKE 'billing_agregation%' OR \
−
  --ignore-table=${mydb}.message \
+
  \`Tables_in_${mydb}\` LIKE 'daily_reports_sended' OR \
−
  --ignore-table=${mydb}.register \
+
  \`Tables_in_${mydb}\` LIKE 'geoip%' OR \
−
  --ignore-table=${mydb}.register_failed \
+
  \`Tables_in_${mydb}\` LIKE 'livepacket%' OR \
−
  --ignore-table=${mydb}.register_state \
+
  \`Tables_in_${mydb}\` LIKE 'register%' OR \
−
  --ignore-table=${mydb}.rtp_stat > /tmp/settings.sql
+
  \`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

Latest revision as of 10:32, 5 November 2021

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