Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

[Public release] Automated backup module

Subscribe

Get notified when there's activity on this post

This question has been flagged
backupdumpautomatizeodoo8.0dumps
1 Reply
7614 Views
Avatar
Yenthe Van Ginneken (Mainframe Monkey)

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 

1
Avatar
Discard
Avatar
Yenthe Van Ginneken (Mainframe Monkey)
Author Best Answer

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.

Where can I find it?

You can download it from the Odoo app store or from Github.

What does this module support?

  • 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.

  • ...

How should I install this?

  1. Download the module.

  2. Place it under ../addons/

  3. 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.

  4. Update your modules (Settings > Update Modules List)

  5. Search for the module ("Database Auto-Backup") and install it.

  6. Configure the details as you wish under Settings > Configure Backup. Be sure to test the FTP connection!

  7. 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.

  8. Profit! :)

Alternatively you can read a full tutorial here: http://www.odoo.yenthevg.com/automated-backups-in-odoo/

5
Avatar
Discard
Luke Branch

@Yenthe,

Awesome work, thanks!

Yenthe Van Ginneken (Mainframe Monkey)
Author

@Luke, No problem! You're always free to give feedback or leave thoughts here about the module too :) Have you implemented it on yours?

TidyWay

Yenthe!! Its really awesome!!

Yenthe Van Ginneken (Mainframe Monkey)
Author

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!

Luke Branch

@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.

PY

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.

Yenthe Van Ginneken (Mainframe Monkey)
Author

@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.

Ermin Trevisan

You are the man :-)

Mario Gielissen

Maybe you can add an option for backup the Odoo filestore?

Yenthe Van Ginneken (Mainframe Monkey)
Author

@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!

Arafat Ali

This is the best module so far from the Odoo boss.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Automated backups
backup dump
Avatar
Avatar
Avatar
2
Dec 24
2109
When using backup script, I get an error Solved
backup odoo8.0
Avatar
Avatar
2
Jun 16
4039
Odoo 8 How backup .dump
backup dump
Avatar
Avatar
2
Mar 15
11256
[odoo14]Database backup error: Command `pg_dump` not found.
databases backup dump
Avatar
5
Oct 20
9370
Back up or Failover feature for Odoo 8.0
failover backup odoo8.0
Avatar
0
May 19
2880
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now