Difference between revisions of "Other way to backup GUI settings"
Jump to navigation
Jump to search
(Created page with " mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \ --ignore-table=${mydb}.alerts_sended \ --ignore-table=${mydb}.cache_number_location \ --ignore-table=${mydb...") |
|||
| Line 1: | Line 1: | ||
| − | mydb='voipmonitor'; mysqldump -c --no-create-info ${mydb} \ | + | mydb='voipmonitor'; mysqldump -c --skip-triggers --skip-add-locks --no-create-info ${mydb} \ |
--ignore-table=${mydb}.alerts_sended \ | --ignore-table=${mydb}.alerts_sended \ | ||
--ignore-table=${mydb}.cache_number_location \ | --ignore-table=${mydb}.cache_number_location \ | ||
Latest revision as of 21:33, 23 November 2015
mydb='voipmonitor'; mysqldump -c --skip-triggers --skip-add-locks --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)