Difference between revisions of "How to backup settings of users in GUI"
Jump to navigation
Jump to search
Line 2: | Line 2: | ||
mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \ | mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \ | ||
+ | --ignore-table=${mydb}.alerts_sended \ | ||
--ignore-table=${mydb}.cache_number_location \ | --ignore-table=${mydb}.cache_number_location \ | ||
--ignore-table=${mydb}.cdr \ | --ignore-table=${mydb}.cdr \ |
Revision as of 18:41, 23 November 2015
Run in bash following command to dump only users settings to /tmp/settings.sql
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