Automatic Database Backup in Easy Instance
Data is the backbone of every application, and ensuring its safety is critical for uninterrupted business operations. In Easy Instance, automatic database backup plays a vital role in protecting your system from data loss caused by server failures, accidental deletions, or unexpected crashes.
This blog explores how Easy Instance simplifies database backup management by offering multiple reliable and secure storage options. With support for popular backup methods such as FTP, SFTP, Google Drive, Nextcloud, Dropbox, and Amazon S3, users can choose a solution that best fits their infrastructure and security requirements. These automated backups run seamlessly in the background, reducing manual effort while ensuring that your data is always recoverable when you need it most.
By implementing automatic database backups in Easy Instance, you gain peace of mind, improved disaster recovery readiness, and greater control over your critical data.
FTP:
Before setting up FTP backups, ensure that an FTP service is installed and running on the destination server (domain machine).
*Select FTP as the backup destination.
*Enter the FTP Host, Port, Username, and Password.
*Specify the FTP Path where the backup files should be stored.
*Test the connection to verify that the credentials and path are correct.
SFTP:
Before configuring SFTP backups, ensure that the SSH/SFTP service is installed and running on the destination server (domain machine).
* Select SFTP as the backup destination.
*Enter the SFTP Host, Port, User, and Password.
*Specify the SFTP Path where the backup files should be stored.
*Test the connection to confirm proper authentication and directory access.
Google Drive:
To configure backups to Google Drive:
Step 1: Create a Google API Project
* Log in to the Google Cloud Console and create a new project.
* From the sidebar select API and Services then Enable the Google Drive API.
*Search google drive api and enable it.
Step 2: Create Credentials
*Go to OAuth consent screen and create Project configuration by clicking get started
* Go to Clients and create new Client by selecting OAuth Client ID.
Step 3: Configure Authorized Redirect URI
* Select Application Type as Web Application.
* Under Authorized JavaScript Origins, add your company’s Odoo URL.
* Under Authorized Redirect URIs, add the redirect uri shown in the bckup configuration page.
* After completing the steps click create button, a Client ID and Client Secret will be generated—copy these credentials.
* After this, open the OAuth consent screen and, under Audience, add the current login email as a Test User to allow access to the app, or complete the app publishing process.
Step 4: Configure Odoo Backup Settings
* Enter the Client ID and Client Secret in the respective fields within the Odoo Backup Configuration.
* Enter the Drive folder id from the folder url.
* After configuration, click on Setup OAuth Token, which will redirect you to an authorization page.
* Grant access and continue.
* Once the token is generated, backups will be uploaded to Google Drive as scheduled.
* A Re-Authorize button will be available—clicking it will refresh the token if needed.
* If you want to take the backup now click the button 'backup now'.
*Backups will be created in the folder as per the backup frequency.
Dropbox :
Navigate to the Dropbox Developers App Console and create a new app.
Step 1: Create a New App
Step 2: Retrieve App Key and Secret.
Once the app is created, you will receive the App Key and App Secret,Also add the Redirect URIs as shown in the screenshot.
Step 3: Set Permissions.
Choose your app's permissions and click submit to save the changes.
Step 4: Configure Backup in Odoo
* In Odoo, go to Backup Configuration and choose Dropbox as the backup destination.
* Enter the App Key, App Secret, and Dropbox Folder Name (same as the folder name in Dropbox).
* Click on Setup OAuth Token to generate the token.
* Grant access and continue.
* Once the token is generated, backups will be uploaded to Dropbox as scheduled.
* If you want to take the backup now click the button 'backup now'.
*Go to home page and check the folder for backup.
Nextcloud :
To configure your Odoo backup to store files on nexcloud:
Step 1: Create a NextCloud Account:
* Visit NextCloud Sign-Up.
* Enter your email address and click Sign Up.
Step 2: Log in to NextCloud
* After signing up, you will be redirected to a login page.
* Enter your email and password to access your account.
Step 4: Configure Backup in Odoo
* Select NextCloud as the backup destination.
* Enter the following details:
a. Domain Name (retrieved in Step 3)
b. Username
c. Password
d. Folder Name (where the backup will be stored)
*Take the domain from the url.
* Test the Connection
*Backups will be created in the folder as per the backup frequency.
Amazon S3:
To configure Amazon S3 as your backup destination, follow these steps:
Step 1: Create an Amazon S3 Account:
* Go to Amazon S3 Sign-Up.
* Enter your email address and complete the sign-up process.
Step 2: Generate Access Keys
* After creating your account, navigate to Account Security Credentials.
* Go to Access Keys and create a new access key.
* Copy the Access Key and Secret Key for later use.
Step 3: Create an S3 Bucket
* In the AWS Management Console, click on Services .
* Navigate to Storage -> S3.
* Click on Create Bucket.
* Follow the naming rules and Click Create Bucket to complete the setup, and you will see the Bucket Folder as shown in the screenshot.
Step 4: Configure Backup in Odoo
* In Backup Configuration, select Amazon S3 as the backup destination.
* Enter the following details:
a. Amazon S3 Access Key
b. Amazon S3 Secret Key
c. Bucket Name (the bucket you created in Step 3)
d. File Name (folder name where the backup will be stored inside the bucket)
* Click on the Test Connection button to verify the setup.
*Backups will be created in the folder as per the backup frequency.
