Setting Up Dropbox Backups

We always recommend customers to maintain backup of their data in Lyte ERP. The database backup is downloaded in the form of an SQL file. If needed, this SQL file of backup can be restored in the another Lyte ERP account as well.

You can automate database backup download of your Lyte ERP account into your Dropbox account.

To setup Dropbox Backup, > Home > Integrations > Dropbox Settings

Steps are different for LyteERP managed versions and open-source versions

LyteERP Managed Version Instructions

Step 1: Set Frequency

Set Frequency to download backup in your Dropbox account.

set frequency

Step 2: Allow Dropbox Access

After setting frequency and updating other details, click on Allow Dropbox access . On clicking this button, the Dropbox login page will open in the new tab. This might require you to allow pop-up for your Lyte ERP account.

Login to your Dropbox account by entering login credentials.

Login

Step 4: Allow

On successful login, you will find a confirmation message as following. Click on "Allow" to let your Lyte ERP account have access to your Dropbox account.

Allow

With this, a folder called "Lyte ERP" will be created in your Dropbox account, and database backup will start to auto-download in it.

Open Source Version Instructions

https://www.dropbox.com/developers/apps

Step 2: Create a new Dropbox app

Create new

Step 3: Fill in the details for your new app

Choose Dropbox API and type as APP Folder - Setup APP Name

Step 4: Insert your custom domain Redirect URI

https://{yourwebsite.com}/api/method/frappe.integrations.doctype.dropbox_settings.dropbox_settings.dropbox_auth_finish Set Redirect URL

Step 5: In a new window, open the Dropbox Settings page in your LyteERP installation

Step 6: Set backup frequency and email

Set the frequency to download your site backups to your Dropbox account. set frequency

Step 7: Input Keys from your Dropbox App window

From your Dropbox App page, enter the app key and (unhidden) app secret into the LyteERP Dropbox settings page.

Alternatively, you can enter it manually in sites/{sitename}/site_config.json as follows,

       {
 "db_name": "demo",
 "db_password": "DZ1Idd55xJ9qvkHvUH",
 "dropbox_access_key": "ACCESSKEY",
 "dropbox_secret_key": "SECRECTKEY"
}

Step 8: Click Save before continuing!!!

Step 9: After saving, click "Allow Dropbox Access"

The Dropbox login page will open in the new tab. This might require you to allow pop-up for your Lyte ERP account.

Step 11: Allow Dropbox Access

On successful login, you will find a confirmation message as following. Click on "Allow" to let your Lyte ERP account have access to your Dropbox account. Allow

Step 12: Confirm Backups Work

From the LyteERP Dropbox page, click Take Backup Now and then go to you Dropbox files view. You should see a new folder in Dropbox named Apps and inside of it your {New App} folder. Inside of it should be backup folders for both files and database. So for an app named lyte-erp , following are the folder locations:

Database files: /Apps/lyte-erp/database
Public files: /Apps/lyte-erp/files
Private files: /Apps/lyte-erp/private/files

> Note : If the compressed backup size exceeds 1GB (Gigabyte), the system will upload the latest available backup to Dropbox instead of generating a new backup file.