How To Take Automated Backups of Your Odoo Database.

odoo
  • by bista-admin
  • Nov 27, 2014
  • 0
  • Category:

Database Auto Backup module is basically used for creating database backup at a regular interval automatically. It is performed at a scheduled time which needs to be mentioned at the time of configuring the module.

Steps for configuring the Module:

1) After installing the module, will have to create a scheduler.

For eg. (for Ver. 8.0) Go to Settings > Automation > Scheduled Actions. (as shown below)

Odoo Implementation

Following things needs to be taken care while configuring the scheduler:

i) Interval Number: It indicates interval time between the next backup schedule run.

ii) Interval Unit: It works in combination with the Interval number as it contains the unit for interval for eg. In the above snapshot the interval time is set for 5 minutes.

iii) Next Execution Date: It carries the next run time along with the dates, While configuring for the first time we have to set the time from here.

iv) Number of Calls: It indicates the number of times the schedule action will happen, Its recommended to keep a negative value (eg. -1), so that it runs infinite times without being stopped.

v) Repeat Missed checkbox needs to be kept unchecked.

vi) Under Technical Data tab, set the value for ‘Object’ to ‘db.backup’ and ‘Function’ to ‘schedule_backup’.

2) Configure Backup:

Go to Settings > Configure Backup (as shown below).

Odoo Customisation

Following things needs to be taken care while configuring the Backup:

i) Host: It should be set to localhost or the appropriate host name.

ii) Database: Mention the name of the database which needs to be backup.

iii) Port: Mention the appropriate port number.

iv) Backup Directory: Mention the location of the directory where the backup files needs to be stored on the system.

Note: Make sure the destination directory has full rights, to avoid permission issues. Once all the configuration is done, the backup will be executed at its scheduled time and a .sql file would be available at the mentioned location.

If you want assistance with this or are looking for consultations regarding Odoo implementation, you can get in touch using our contact form.

Contact Us

    Our Clients Reviews

    “What stood out about Bista was definitely the responsiveness from the point that we made the
    first contact, they were very quick to respond to my query…and then we scheduled. Because I was
    on a very tight deadline. I wanted it up and running within a month…. They were responsive, they had a team dedicated [to take care of what was happening] …people working around the clock.”

    SuperAsia Foods
    Aqib Majid

    “I think Bista’s been a great partner. It’s one of the reasons we’ve been working with them for multiple years
    now, even after the initial project finished. I think they have a great talent pool to work with and they’ve been
    very accommodating – so wherever we needed to change things or get additional resources or find additional
    expertise they’ve always been on point to help with that.” 

    Pinnacle Promotions
    Sean Phuphanich

    “[Bista’s] understanding of core business processes and needs is unmatched and unparalleled in their industry. Through working with Bista, we’ve got quantifiable results and qualitative results. We’ve been able to increase our sales double while lowering our back-order fulfillment rate. Previously we were fulfilling with the rate of 85% and since using Bista we’ve increased that to 97%.”

    Maqabim Distributors
    Michael Sturury