Protecting your Odoo ERP data is critical. Data loss — from human error, server failure, or malicious events — can halt business operations and incur severe financial loss. At Odiware, we recommend a hybrid backup strategy: manual backups for immediate control and automated backups for reliability and consistency. Let’s explore both approaches.
What Is a Database Backup?
A database backup is a copy of your Odoo database and associated files (like attachments) that can be restored in case your live system becomes unavailable or corrupted. Backups help ensure business continuity.
There are two common backup formats:
- ZIP (with filestore) – Includes the database dump plus attachments, images, binary files, etc.
- pg_dump (without filestore) – Contains only the database schema and data.
Manual Backup Using Odoo Interface
Manual backups are the simplest way to protect your data, especially before upgrades or major changes.
Steps for Manual Backup
1. Log in to your Odoo instance and navigate to the Database Manager.
2. Click “Backup” next to the database you want to protect.
3. Choose the backup format (ZIP if you want filestore included).
4. Enter your master password (required for backup/restore operations).
5. Download and store the backup in a safe location.
Note: Always download the backup file to an external drive or cloud location to avoid losing it if your server is compromised.
Restore Odoo Database
Restoring from a backup is just as important as creating one.
How to Restore
1. Open the Database Manager via https://<odoo-web-url>/web/database/manager.
2. Click “Restore Database.”
3. Upload the backup file you previously downloaded.
4. Provide your master password and choose a new database name.
5. Start the restore process and wait until completion.
This process will recreate your database to the backup state, including all records and files included in the backup.
Automated Backup with OCA Auto_Backup Module
Manual backups are useful, but relying only on them can lead to gaps. That’s where scheduled automated backups come in.
The OCA (Odoo Community Association) auto_backup module in the server-tools repository provides a reliable way to automate database backups at regular intervals without manual intervention.
What It Does
With the OCA auto_backup module, you can:
- Schedule backups at regular intervals (daily/weekly/monthly)
- Automatically store backups in predefined locations
- Manage retention by keeping only recent backups
- (Optional) Write backups to an external server through secure protocols
- Receive notifications on failures (configurable)
The module ships as part of the OCA server-tools collection, maintained by the community to extend Odoo admin capabilities.
Setup & Configuration
1. Install the Module
- Add the auto_backup folder from the OCA server-tools repo into your Odoo addons path.
- Update apps and install auto_backup.
2. Configure Backup Schedule
- Define how often backups should run (e.g., every day at 2 AM).
- Set the backup storage path (local directory or external server).
3. Retention Policy
- Configure how many recent backups to keep. Older backups get cleaned up automatically.
4. Remote Server Sync (Optional)
- If you want off-site redundancy, connect to an SFTP/remote server using secure authentication.
5. Notifications (Optional)
- Configure email alerts for success/failure of scheduled backups.
Once configured, Odoo will run backups consistently without admin involvement.
Best Practices for Odoo Backups
- Keep multiple backup copies in different locations (local + cloud).
- Test your backups by performing restores regularly to detect issues early.
- Use automated backups for production environments.
- Schedule backups during off-peak hours to reduce performance impact.
At Odiware, we recommend combining manual backups (for immediate on-demand control) with an automated solution like the OCA auto_backup module to ensure your Odoo ERP remains robust and resilient against data loss.
Have questions about setting up automated backups or need custom Odoo support?
Contact Odiware Experts for guidance and implementation assistance.
