Difference between revisions of "How to backup settings of users in GUI"
Jump to navigation
Jump to search
(Created page with "mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \ --ignore-table=${mydb}.cache_number_location \ --ignore-table=${mydb}.cdr \ --ignore-table=${mydb}.cdr_dtmf \...") |
|||
| Line 1: | Line 1: | ||
| − | mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \ | + | 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}.cache_number_location \ | --ignore-table=${mydb}.cache_number_location \ | ||
--ignore-table=${mydb}.cdr \ | --ignore-table=${mydb}.cdr \ | ||
Revision as of 18:40, 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}.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