Enable Dark Mode!
automatic-database-backup-odoo-16-app.jpg
By: Prayag K

Automatic Database Backup - Odoo 16 App

Technical Odoo 16 Odoo Apps

This Automatic Database Backup module makes it easier to create automatic database backups periodically. The created backups can be kept on a local drive, an FTP server, an SFTP server, a dropbox account, a Google Drive account, or a OneDrive account. The ability to automatically discard outdated backups can be enabled by the user. Users have the option to opt-in to email alerts for successful or unsuccessful backup generation and storage. Users can create and store database backups in numerous locations by using the Automatic Database Backup module.

Dropbox is a third-party Python dependency used by this module. Install the Python package first, then the module. The following command can be used to install the necessary Python package:

pip install dropbox

The main features of this App

1. Generate Database Backups at regular intervals

2. Generated backup can be stored on Google Drive

3. Store Backup to Remote Server

4. Store Backup to Dropbox

5. Store Backup to Onedrive

6. Automatically remove old backups

7. Notify the user of the success and failure of backup generation

Let’s see how to configure the App:

Step 1: First, Install Odoo 16 Automatic Database Backup To Local Server, Remote Server, Google Drive, Dropbox, and Onedrive Module 

Download the app from the Odoo store using the link above and install it.

Odoo App Link Automatic Database Backup To Local Server, Remote Server, Google Drive, Dropbox and Onedrive,

Automatic Database Backup - Odoo 16 App-cybrosys

Database Backup Configuration Menu:

Goto Setting - Technical - Backup Configuration to configure backups

Automatic Database Backup - Odoo 16 App-cybrosys

Create New Database Backup Configuration

Enter the Database name and Master Password. Indicate the backup's destination and kind. Enter the location of your backup directory; if one doesn't already exist, a new directory will be created. And we can also select the Backup in Zip or Dumb format.

Automatic Database Backup - Odoo 16 App-cybrosys

Store Backup to Remote SFTP Server

Enter credentials and choose SFTP as the backup destination. To determine whether the connection is successful, click the Test Connection option.

Automatic Database Backup - Odoo 16 App-cybrosys

Store Backup to Remote FTP Server

Enter credentials and choose FTP as the backup destination. To determine whether the connection is successful, click the Test Connection option. 

Automatic Database Backup - Odoo 16 App-cybrosys

Store Backup to Google Drive

You must activate the Google Drive API and start a new Google API project in order to save backups in Google Drive. Log in to your Google API Console account. When constructing the project, copy the URI of your Odoo database followed by /google_drive/authentication for the Redirect URI limitations. Example:

Automatic Database Backup - Odoo 16 App-cybrosys

Enable Google Drive API

Automatic Database Backup - Odoo 16 App-cybrosysAutomatic Database Backup - Odoo 16 App-cybrosys

Establish credentials, When prompted to choose an application type, choose website application.

Automatic Database Backup - Odoo 16 App-cybrosys

Click + Add URI in the Authorized JavaScript Origins box and enter the Odoo URL for your business. Click + Add URI in the Authorized redirect URIs box, then enter the URL for your company's Odoo system, followed by the phrase "/google_drive/authentication." Once each step has been finished, You will be issued a client ID and secret; copy the credentials.

Automatic Database Backup - Odoo 16 App-cybrosys

Create a backup. Paste the Client ID and Client Secret from the Google Drive API Credentials page into the relevant fields.

Automatic Database Backup - Odoo 16 App-cybrosys

Setup Tokens, a page for authorizing transactions will be displayed.

Automatic Database Backup - Odoo 16 App-cybrosys

Automatic Database Backup - Odoo 16 App-cybrosys

Reset the token if required.

Automatic Database Backup - Odoo 16 App-cybrosys

Store Backup to Dropbox

Choose Dropbox as that of the backup destination. Enter the app secret and key. A new app must be registered in the App Console. Choose the Dropbox API app and the permissions for your application (files.content.write and files.content.read permissions required). 

Install the Dropbox library for Python (pip instal dropbox).

Automatic Database Backup - Odoo 16 App-cybrosys

Create a refresh token.

Automatic Database Backup - Odoo 16 App-cybrosys

Click confirm after getting the authorization code.

Automatic Database Backup - Odoo 16 App-cybrosys

If necessary, reset the refresh token.

Automatic Database Backup - Odoo 16 App-cybrosys

Store Backup to Onedrive

Choose OneDrive as the backup location. Enter the App secret and App key. A new app must be registered on the Microsoft Azure site. Create a backup. Paste the Client ID and Client Secret from the Google Drive API Credentials page into the relevant fields. Example:

Automatic Database Backup - Odoo 16 App-cybrosys

Copy the Client ID

Automatic Database Backup - Odoo 16 App-cybrosys

Generate Client Secrets.

Automatic Database Backup - Odoo 16 App-cybrosysAutomatic Database Backup - Odoo 16 App-cybrosys

Find the one drive folder ID for the backup file storage location.

Automatic Database Backup - Odoo 16 App-cybrosys

Configure the backup

Automatic Database Backup - Odoo 16 App-cybrosys

Setup Tokens, a page for authorizing transactions will be displayed.

Automatic Database Backup - Odoo 16 App-cybrosys

Automatic Database Backup - Odoo 16 App-cybrosys

If necessary, reset the token.

Automatic Database Backup - Odoo 16 App-cybrosys

Automatically Remove Old Backups

Set the amount of days to delete backups and enable the auto-remove option.

Automatic Database Backup - Odoo 16 App-cybrosys

Notify the User of the Success and Failure of Backup Generation

Select a user to inform by turning on the option to notify users. When a backup is successful or unsuccessful, the specified user will get an email.

Automatic Database Backup - Odoo 16 App-cybrosys

a successful email backup notice

Automatic Database Backup - Odoo 16 App-cybrosys

email notification of backup creation failure

Automatic Database Backup - Odoo 16 App-cybrosys

Scheduled Action For Generating Backup

Set the execution interval and enable the scheduled operation "Automatic database backup." Backups will be created on a regular basis in accordance with the arrangement for the planned activity.

Automatic Database Backup - Odoo 16 App-cybrosysAutomatic Database Backup - Odoo 16 App-cybrosys

The Automatic Database Backup To Local Server, Remote Server, Google Drive, Dropbox, and Onedrive App for Odoo-16 functionalities have all been covered in this article. I hope you all comprehend how it should function.


If you need any assistance in odoo, we are online, please chat with us.



2
Comments

Matthias HOEPPNER

Hello, I am not sure if you got my previous comment here cause there was no message / feedback on the website. So again: I installed your app that seem to be exactly what we need. I installed the requirements in the venv where our Odoo16 is running like pip install dropbox... During various test I changed the folder permissions in the addons directory from drwxr-xr-x 10 root odoo 4,0K Nov 9 20:10 auto_database_backup (like all other addons) to drwxrwxrwx 10 root odoo 4,0K Nov 9 20:10 auto_database_backup The local backup path has now drwxrwxrwx too. Nextcloud credentials, databas name and password are correct... However I always get the error access denied. What can I do, what did I miss. Looking forward to get your feedback be email to mh@rad3.de. Thanks a lot. Mit freundlichen Grüßen / Best regards Ihr rad3-Team Matthias Höppner -- rad3 UG (haftungsbeschränkt) Transporträder für Familie, Freizeit und Beruf Laden +49 341 3928739 Besuchen Sie uns: D-04177 Leipzig Geschäftssitz & Service: Erich-Köhn-Str. 63b Verkauf & Büro: Delitzscher Str. 97, 04129 Leipzig https://rad3.de/ https://www.facebook.com/rad3de https://instagram.com/rad3de Rechtliche Angaben zum Unternehmen unter https://rad3.de/impressum

10/11/2023

-

7:43AM

Matthias HOEPPNER

Hello, got your great app. It is installed on an test enviroment and seems to run. In the meantime I changed the folder permission in my ..../addons for testing from drwxr-xr-x 10 root odoo 4,0K Nov 9 20:10 auto_database_backup to drwxrwxrwx 10 root odoo 4,0K Nov 9 20:10 auto_database_backup. However, whatever I try, local backup or Nextcloud, I always get the error Access Denied. I run out of ideas (and I am not an IT specialist ;-)), database name and password are correct, backup path is set to drwxrwxrwx too and should not cause the problem. Nextcloud credentials are tested and correct... Would be great to get your feedback / recommondation by email, thanks. Best regards Matthias

10/11/2023

-

7:16AM



Leave a comment

 


whatsapp
location

Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635

location

London

Cybrosys Limited
Alpha House,
100 Borough High Street, London,
SE1 1LB, United Kingdom

location

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

location

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message