Backup ODOO [Local, Remote, Drive, Dropbox, Amazon S3]
by Hilar AK https://automaticbackup.odoo.com/$ 31.16
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
Discuss (mail)
|
Lines of code | 1508 |
Technical Name |
auto_backup_odoo |
License | OPL-1 |
Website | https://www.linkedin.com/in/hilar-ak/ |
Versions | 8.0 9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0 17.0 18.0 |
BACKUP
ODOO DATABASES & FILESTORE
Available Odoo Backup DB/Filestore
Modes:
- Local
- Remote Server
- Google Drive
- Dropbox
- Amazon S3
Module For backup ODOO databases and
automating the backup process of ODOO.
- Multiple Backup Modes
- Filestore Backup
- Backup ODOO Databases in specified path
- Detailed Message Log
- Backup Status Information and History
- User can select the format to dump, either custom archive, plain text SQL or tar archive
- Archive Backup Process
- Repeat Missed Backup Process
- Backup to Amazon S3
Features
- Dump ODOO Database in specified format
- Zip filestore in a specified location
- Output a custom archive suitable for input into pg_restore. This is the most flexible format in that it allows the reordering of loading data as well as to object definitions. This format is also compressed by default. Here we user gzip ie, test.gz, We also recommend you to select Custom, because Using the custom format you can restore single objects from a backup.
- Output a plain-text SQL script file (the default). The plain text format is useful for very small databases with a minimal number of objects but other than that, it should be avoided.
- Output a tar archive suitable for input into pg_restore. Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. It is also possible to limit which data is reloaded at restore time. we use tar with gzip
- Backup Filestore
- Multiple backup modes at sametime
- ODOO Backup to Amazon S3
- ODOO Backup to Google Drive
- ODOO Backup tp Dropbox
- ODOO Backup to remote server
Tech
Odoo Auto Backup Module uses
- PYTHON - Models
- XML - Views
- HTML - UI
- Twitter Bootstrap - UI
- backbone.js - Views
- jQuery
- PSQL - DB
External
Dependencies
- PYSFTP
pip install pysftp
- Dropbox
pip install dropbox
- Progress Meter
pip install tqdm
- Boto3
pip install boto3
- Botocore
pip install botocore
Installation
Install the odoo13 and Auto Backup
module.
After installation you can configure backup under general settings. If you are using the google
drive mode,
then msust enable the google integration under general settings and update the google drive
refresh
token.
CHANGELOGS
Date: 07/12/2020
- Performance Improvement
- Session Upload Trace For Dropbox Files > 150 mb
- Full Metadata Track In Message Logs
- Fix Dropbox Tar files upload
- Progress Meter In Logs
Date: 22/11/2020
- Amazon S3 Database Backup
- Amazon S3 Filestore Backup
Todos
- Backup Dashboard
Author
Hilar AK
Git
Repository
Hilar AK
Configurations
Cron Job To Enable Automatic Backup
New Record
Records
Backup Modes
Local
Remote
Google Drive
Dropbox
Amazon S3
Installation Guide: Python Packages with pip and Virtual Environments
Installing Python Packages with pip
Python packages can be easily installed using pip, the package installer for Python. Follow the steps below to install packages using pip:
- Open your command-line interface (e.g., Terminal, Command Prompt).
- Check if pip is installed by running the following command: bash
#!/bin/bash $ pip --version
If pip is not installed, you can install it by following the official documentation athttps://pip.pypa.io/en/stable/installing/.
To install a package, use the following command:
$ pip install package\_name
Replace package_name with the name of the package you want to install.
Example: To install the pysftp, dropbox, tqdm, simplejson package, run:
$ pip install pysftp dropbox tqdm simplejson
You can install multiple packages by listing them with spaces:
$ pip install package1 package2 package3
To install a specific version of a package, use the following command:
$ pip install package\_name==version\_number
Replace version_number with the desired version of the package.
Example: To install version 2.2.0 of the numpy package, run:
$ pip install numpy==2.2.0
- If you don’t specify a version, pip will install the latest version available.
Installing Packages within a Virtual Environment
Using a virtual environment is a recommended practice to manage Python packages for specific projects. Follow the steps below to install packages within a virtual environment:
- Create a new virtual environment by running the following command:
$ python -m venv env\_name
Replace env_name with the desired name for your virtual environment.
Activate the virtual environment:
- On Windows:
$ .\env\_name\Scripts\activate
On macOS and Linux:
$ source env_name/bin/activate
Once the virtual environment is activated, use pip to install packages as described in the previous section. The packages will be installed within the virtual environment and won't interfere with other Python installations.
To deactivate the virtual environment, simply run the following command:
$ deactivate
- This will return you to your regular command-line environment.
Using virtual environments helps maintain clean and isolated environments for different projects, ensuring package dependencies are managed effectively.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module
Report comment
Any abuse of this reporting system will be penalizedGreat Application!!
Re: Great Application!!
Thanks for your appreciation. :)
Can we have a trial?
Hello.
I would like to test the app, is possible?
Odoo 11 CE.
Regards.
I this module support docker ?
Hi there!
We've been using your app and it's been working fine except for one issue we just encountered. When we changed the format to Plain Text/SQL, the backup still saves to zip and only contains filestore. No sql dump. It's unable to output backup to sql file. We're using Odoo 13EE. Your immediate response is very much appreciated.
Re:
Hello,
It must be related to your odoo deployment and check your odoo conf file. db_user and db_password are required to get DB backups. Please update accordingly and check the status. You can write queries to hilarak@gmail.com
I have tested it now on a server other than odoo.sh but facing the same behavior. Only getting backup of filestore but not database.
Re:
Then please update your odoo conf with db user and db password parameter and give the same in backup conf form
Need Help
We have deployed this module on odoo.sh and its creating only filestore backups. I dont know why its not creating database backup. Can you check it.
Re: Need Help
The module can't access the database from odoo.sh. Where odoo is not permitted database access using psql role.
About set config : If I set config : list_db = True . Module can run?
Pls, I want to buy this module.
But I have a answer.
If I set config : list_db=False (in file config), Module can run or can't run?
Thanks
About set config : If I set config : list_db = True . Module can run?
Pls, I want to buy this module.
But I have a answer.
If I set config : list_db=True (in file config), Module can run or can't run?
Thanks
Re: About set config : If I set config : list_db = True . Module can run?
yes. The module is doing operations in the server by accessing your DB and filestore. Not from UI
I have just bought the module but cant download
Hello,
I have just bought the module but I dont get the link to download it
please help
backup file 8Gb question?
I already have one backup module but its unable to upload google drive. Giving error Memory Error because my backup file is 8gb ? Is this module solve that issue ?
usr/lib/python2.7/dist-packages/secretstorage/dhcrypto.py:15: CryptographyDeprecationWarning: Python 2 is no longer supported by the Python core team. Support for it is now deprecated in cryptography, and will be removed in the next release.
from cryptography.utils import int_from_bytes
DEPRECATION: Python 2.7 reached the end of its life on January 1st, 2020. Please upgrade your Python as Python 2.7 is no longer maintained. pip 21.0 will drop support for Python 2.7 in January 2021. More details about Python 2 support in pip can be found at https://pip.pypa.io/en/latest/development/release-process/#python-2-support pip 21.0 will remove support for this functionality.
Requirement already satisfied: pysftp in /usr/local/lib/python2.7/dist-packages (0.2.9)
Requirement already satisfied: paramiko>=1.17 in /usr/local/lib/python2.7/dist-packages (from pysftp) (2.7.2)
Requirement already satisfied: cryptography>=2.5 in /usr/local/lib/python2.7/dist-packages (from paramiko>=1.17->pysftp) (3.3.2)
Requirement already satisfied: pynacl>=1.0.1 in /usr/local/lib/python2.7/dist-packages (from paramiko>=1.17->pysftp) (1.4.0)
Requirement already satisfied: bcrypt>=3.1.3 in /usr/local/lib/python2.7/dist-packages (from paramiko>=1.17->pysftp) (3.1.7)
Requirement already satisfied: ipaddress; python_version < "3" in /usr/lib/python2.7/dist-packages (from cryptography>=2.5->paramiko>=1.17->pysftp) (1.0.17)
Requirement already satisfied: cffi>=1.12 in /usr/local/lib/python2.7/dist-packages (from cryptography>=2.5->paramiko>=1.17->pysftp) (1.14.5)
Requirement already satisfied: six>=1.4.1 in /usr/local/lib/python2.7/dist-packages (from cryptography>=2.5->paramiko>=1.17->pysftp) (1.16.0)
Requirement already satisfied: enum34; python_version < "3" in /usr/lib/python2.7/dist-packages (from cryptography>=2.5->paramiko>=1.17->pysftp) (1.1.6)
Requirement already satisfied: pycparser in /usr/local/lib/python2.7/dist-packages (from cffi>=1.12->cryptography>=2.5->paramiko>=1.17->pysftp) (2.20
Re:
This module is for odoi v13 and it supports python3. You are trying to install dependency in python 2.7, which is wrong.
Unable to install module "auto_backup_odoo" because an external dependency is not met: Python library not installed: pysftp
Re:
Module readme filr is explained with the dependent packages and you can see one requirements file in module. This file need to be installed.
Nice to Have
Hi,
Nice Idea however
what about restoration, how does it work then ?
thnx
Re: Nice to Have
You can use odoo restoration view. but I won't recommend that. Better to do restore with psql directly. The main target of module is to deal with large databases in gbs.
Hello, I am interested in backing up in google drive
Hello, I am interested in backing up in google drive but I have several databases in a saas and I want it to be in a .zip file and that it has the file store
Re: Hello, I am interested in backing up in google drive
You please contact me @ hilarak@gmail.com Or Skype hilar.ak1
Great App and Great Support
I was very surprised on the quick response from the developer. Was impressed with his support. Will purchase from him again. Thank you, Sander Richiez
Re: Great App and Great Support
Sure, will do support always. Thanks