How to backup settings of users in GUI
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' OR \ \`Tables_in_${mydb}\` LIKE 'system' \ "| sed -e "s/^/--ignore-table=${mydb}./" |xargs mysqldump -c --skip-triggers --skip-add-locks --no-create-info ${mydb} > /tmp/settings.sql
- 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)