Automatic DB Backup

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Automatic DB Backup

Postby medk » Wed Oct 24, 2018 4:13 am

Hello,

Is there a way to automatically backup the entire asterisk database daily to a usb flash drive connected to the VICIbox server or to DropBox or any other service?

Thanks!
VICIbox 8.1.1
OpenSuSE Leap v.42.3 64-bit
Kernel v.4.4.155
Asterisk v.13.21.1-vici
DAHDI v.2.11.1
LibPRI v.1.6.0
Amfletec VoiceSync v.1.3.8
OpenR2 v.1.3.3 for MFC/R2 support
ViciDial SVN v.2.14-689a build 180922-0958 revision 3035
medk
 
Posts: 26
Joined: Thu Sep 15, 2016 7:02 am

Re: Automatic DB Backup

Postby williamconley » Wed Oct 24, 2018 6:42 am

1) Get yourself a nice FTP server

2) Put the FTP credentials in /etc/astguiclient.conf in the REPORT server connection information section

3) Run once manually to be sure the ftp transfer succeeds:
Code: Select all
/usr/share/astguiclient/ADMIN_backup.pl --without-web --without-sounds --ftp-transfer --debugX


4) Look in /var/log/astguiclient/archive and on the ftp server to verify success

5) You may need to create the "REPORTS" folder on the ftp server manually, it usually doesn't create that folder for you.

6) When the manual run works as you expect: Put this in your crontab -e
Code: Select all
## Vicidial Backup - without web files or sounds (change if you modify web files or recordings)
## Leave before midnight in case of "emergency backup" during the day ... don't overwrite LAST backup, make a new one!
45 23 * * *  /usr/share/astguiclient/ADMIN_backup.pl --without-web --without-sounds --ftp-transfer >/dev/null 2>&1
#options: --db-only --db-without-logs --without-web --conf-only --without-db --without-conf --without-web --without-sounds
#         --without-voicemail --without-crontab --debugX --debug --test --ftp-transfer
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 66 guests