Hello Evryone,
Currently we know that Dropbox integration with ERPNext allows you to take database backups over Dropbox. But Is there any similar provision about Attachments and files we attach to documents in ERPNext? Does the files also get backup to dropbox along with Database?
Correct, ERPNext copies strictly your database dump sql.gz to DropBox for backup and restore.
Provision to save and restore your public and private file (attachments and so on) is the responsibility of each individual site, for example to schedule a cron process to say compress and scp the files to a remote archive such as DropBox.
Those public and private files can be found here:
frappe@erpnext:~/frappe-bench$ ls -al sites/erpnext.vm/private/
total 16
drwxrwxr-x 4 frappe frappe 4096 Aug 28 15:03 .
drwxrwxr-x 7 frappe frappe 4096 Aug 31 14:50 …
drwxrwxr-x 2 frappe frappe 4096 Nov 3 16:50 backups
drwxrwxr-x 2 frappe frappe 4096 Aug 28 15:03 files
frappe@erpnext:~/frappe-bench$ ls -al sites/erpnext.vm/private/backups/
total 3328
drwxrwxr-x 2 frappe frappe 4096 Nov 3 16:50 .
drwxrwxr-x 4 frappe frappe 4096 Aug 28 15:03 …
-rw-rw-r-- 1 frappe frappe 1124200 Nov 3 16:28 20171103_172820-erpnext_vm-database.sql.gz
-rw-rw-r-- 1 frappe frappe 1135579 Nov 3 16:34 20171103_173403-erpnext_vm-database.sql.gz
-rw-rw-r-- 1 frappe frappe 1130585 Nov 3 16:50 20171103_175008-erpnext_vm-database.sql.gz
frappe@erpnext:~/frappe-bench$ ls -al sites/erpnext.vm/private/backups/^C
frappe@erpnext:~/frappe-bench$ ls -al sites/erpnext.vm/public/
total 12
drwxrwxr-x 3 frappe frappe 4096 Aug 28 15:03 .
drwxrwxr-x 7 frappe frappe 4096 Aug 31 14:50 …
drwxrwxr-x 2 frappe frappe 4096 Aug 28 15:03 files
frappe@erpnext:~/frappe-bench$ ls -al sites/erpnext.vm/public/files/
total 8
drwxrwxr-x 2 frappe frappe 4096 Aug 28 15:03 .
drwxrwxr-x 3 frappe frappe 4096 Aug 28 15:03 …
On self hosted my drop box backup does files also I did not have to do anything special @clarkej are you not seeing this on your site?
Thank you imllc, my error I stand corrected @Deep - yes one can include files too, it simply depends on what folders you specify to copy