Hi guys,
Is there any tool available that automatically takes backups from my Odoo databases?
I'd like to automate this and keep my back-ups both locally and external on an FTP server.
Thanks,
Yenthe
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi guys,
Is there any tool available that automatically takes backups from my Odoo databases?
I'd like to automate this and keep my back-ups both locally and external on an FTP server.
Thanks,
Yenthe
Since a while I've been search for a back-up tool but didn't find what I wanted so I decided to build my own module. I've started from the Odoo V6.0 module and then started expanding it.
You can download it from the Odoo app store or from Github.
Automated backups on your own server.
Choose when and how often the backups should be taken.
Automatically creates the directories you specify (note: directly under / is not permitted, so this is the only exception. If the first level folder exists my module can create the rest - if the user you authenticate with has enough system rights.)
Automatically removes old backups when they are older than you've specified.
Connection support to any FTP server that has SSH enabled.
Automatically create the directories on the FTP. (note: directly under / is not permitted, so this is the only exception. If the first level folder exists my module can create the rest - if the user you authenticate with has enough system rights.)
Automated backups on the FTP server.
Automatically removes old backups when they are older than you've specified.
Option to keep external backups longer then local ones, or the other way around.
Automatically e-mail when there is a connection or writing failure to the FTP. (Provided you have e-mail servers configured and have this option checked)
Fully translated in English, Dutch, Chinese and German.
...
Download the module.
Place it under ../addons/
Install pysftp. This lib is needed to have access to an external FTP server. Open an Ubuntu terminal and run the command sudo pip install pysftp to install the lib.
Update your modules (Settings > Update Modules List)
Search for the module ("Database Auto-Backup") and install it.
Configure the details as you wish under Settings > Configure Backup. Be sure to test the FTP connection!
Go to Settings > Automation > Scheduled Actions and open the record "Backup scheduler". Set it to active and specify how often you want the back-ups to be taken.
Profit! :)
Alternatively you can read a full tutorial here: http://www.odoo.yenthevg.com/automated-backups-in-odoo/
@Yenthe,
Awesome work, thanks!
@Luke, No problem! You're always free to give feedback or leave thoughts here about the module too :) Have you implemented it on yours?
Yenthe!! Its really awesome!!
Thanks Tidy, great to hear that! :) Have you managed to get it working at your side? I'd love some feedback about this. & if you really like it, an upvote is always welcome if you feel it is justified!
@Yenthe,
I've just implemented this on a development instance, it looks like a lot of work has gone into this. This looks like it's going to be a valuable part of every Odoo instance I work on. Thanks!
I'll comment back here once i've had more time to work with the module.
Great job Yenthe ! I have a personal hacky script for this sort of thing, but never tried to build a module for this. I will definitely test yours when I have more time.
@Luke thanks, thats great to hear! Keep me updated about your experiences. :) @PY: Thanks! Time for you to switch from buggy to my module then, one thing less to worry about. Let me know how it goes.
You are the man :-)
Maybe you can add an option for backup the Odoo filestore?
@Mario the module creates a .dump which both contains an sql file to restore the db and folder with your filestore, so both are included! :) @Ermin: thanks!
This is the best module so far from the Odoo boss.
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Dec 24
|
798 | ||
|
2
Jun 16
|
3090 | ||
|
2
Mar 15
|
10201 | ||
|
5
Oct 20
|
7657 | ||
|
0
May 19
|
1855 |