How to backup settings of users in GUI

From VoIPmonitor.org
Revision as of 18:39, 23 November 2015 by Petr.halounek (talk | contribs) (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 \...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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