How to Koha Auto Backup in Dropbox

• Install Dropbox in your koha server

•  Create an account in Dropbox 

•  Open Applications > System Tools > Terminal
•  Apply the following command,

crontab -e

•  Use down arrow button and move the cursor to bottom part of the crontab file.

•  Copy and Paste following command in crontab bottom part.

Backup 9.00 AM

*/60 * * * * mysqldump -uroot -pmysqlroot koha_library | xz > /home/koha/Dropbox/koha_library.sql.xz

Backup 3.15 PM

30 15 * * * mysqldump -uroot -pmysqlroot koha_library | xz > /home/koha/Dropbox/koha_library.sql.xz

Apply Ctrl + X, and Y button click Enter to save and close the file.

Information courtesy, Mr. Vimal : http://kohageek.blogspot.com