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

From VoIPmonitor.org
Jump to navigation Jump to search
Line 1: Line 1:
Run in bash following command to dump only users settings to /tmp/settings.sql
+
 
 +
Run in bash following commandline to dump only users settings to /tmp/settings.sql
 +
 
 +
mydb='voipmonitor'; mysql ${mydb} -Ne "show tables from voipmonitor where \
 +
  \`Tables_in_${mydb}\` LIKE 'alerts_%' OR \
 +
  \`Tables_in_${mydb}\` LIKE 'cdr%' OR \
 +
  \`Tables_in_${mydb}\` LIKE '%country%' OR \
 +
  \`Tables_in_${mydb}\` LIKE 'register%' 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 'live_packet' OR \
 +
  \`Tables_in_${mydb}\` LIKE 'message' OR \
 +
  \`Tables_in_${mydb}\` LIKE 'rtp_stat' \
 +
  "| sed -e 's/^/--ignore-table=${mydb}./' |xargs mysqldump -c --no-create-info ${mydb} > /tmp/settings.sql
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
 
 +
######
 +
###### Other way
 +
######
  
 
  mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \
 
  mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \
Line 24: Line 48:
 
   --ignore-table=${mydb}.register_state \
 
   --ignore-table=${mydb}.register_state \
 
   --ignore-table=${mydb}.rtp_stat > /tmp/settings.sql
 
   --ignore-table=${mydb}.rtp_stat > /tmp/settings.sql
 +
 +
But this not work when alerts backup table(s) exists.
 +
(You need to manualy add --ignore-table=voipmonitor.alerts__bck-2015-10-08 for each alerts__bck tables you have in db)

Revision as of 20:04, 23 November 2015

Run in bash following commandline to dump only users settings to /tmp/settings.sql

mydb='voipmonitor'; mysql ${mydb} -Ne "show tables from voipmonitor where \
  \`Tables_in_${mydb}\` LIKE 'alerts_%' OR \
  \`Tables_in_${mydb}\` LIKE 'cdr%' OR \
  \`Tables_in_${mydb}\` LIKE '%country%' OR \
  \`Tables_in_${mydb}\` LIKE 'register%' 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 'live_packet' OR \
  \`Tables_in_${mydb}\` LIKE 'message' OR \
  \`Tables_in_${mydb}\` LIKE 'rtp_stat' \
  "| sed -e 's/^/--ignore-table=${mydb}./' |xargs mysqldump -c --no-create-info ${mydb} > /tmp/settings.sql




            1. Other way
mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \
 --ignore-table=${mydb}.alerts_sended \
 --ignore-table=${mydb}.cache_number_location \
 --ignore-table=${mydb}.cdr \
 --ignore-table=${mydb}.cdr_dtmf \
 --ignore-table=${mydb}.cdr_next \
 --ignore-table=${mydb}.cdr_proxy \
 --ignore-table=${mydb}.cdr_reason \
 --ignore-table=${mydb}.cdr_rtp \
 --ignore-table=${mydb}.cdr_sip_request \
 --ignore-table=${mydb}.cdr_sip_response \
 --ignore-table=${mydb}.cdr_siphistory \
 --ignore-table=${mydb}.cdr_sipresp \
 --ignore-table=${mydb}.cdr_tarpart \
 --ignore-table=${mydb}.cdr_ua \
 --ignore-table=${mydb}.contenttype \
 --ignore-table=${mydb}.files \
 --ignore-table=${mydb}.livepacket \
 --ignore-table=${mydb}.message \
 --ignore-table=${mydb}.register \
 --ignore-table=${mydb}.register_failed \
 --ignore-table=${mydb}.register_state \
 --ignore-table=${mydb}.rtp_stat > /tmp/settings.sql

But this not work when alerts backup table(s) exists. (You need to manualy add --ignore-table=voipmonitor.alerts__bck-2015-10-08 for each alerts__bck tables you have in db)