How to Restore Odoo Database
In this guide, we’ll cover how to restore your Odoo database safely using two main methods:
- Through the Odoo Web Interface
- Through the Command Line (CLI) using PostgreSQL tools
Backup via Odoo Web Interface
1. Open odoo database manager page
Navigate to the following URL:
https://<your-domain>.com/web/database/manager
2. Click on "restore a database"
Click restore a database to open restore database form.
in that form you'll see these fields to input:
- Master password (The master password from your odoo.conf file. This is required for any database operation).
- File (Upload your backup file created via Odoo’s backup interface. It must be a .zip file.)
- Database Name (The new name for your restored database must be unique.)
- Neutralized (If checked, Odoo will anonymize sensitive data. Useful when restoring a production database to a testing or staging environment.)
- This database is a copy (for test or staging copies of a production DB, this option will disables outgoing emails, payment gateways, and webhooks.)
- This database was moved (for when you are migrating or transferring the production DB to a new server, not like "This database is a copy option" this option will keeps configurations active.)
3. Enter Master Password
4. Upload the Backup File and Enter the Database Name
Here’s how to properly fill out the two main fields: Database Name and File (.zip).
1. In the Database Name field, type a new name for your restored database.
2. Upload the Backup File
To upload the backup file, click the Choose File button in the File (.zip) field and select your Odoo backup file from your computer.
Example:
5. Click “Continue”
Once you’ve entered the master password, selected the backup file, and provided the database name, click “Continue” to begin the restoration process.
Restore via Command Line (CLI)
Sometimes, restoring a large Odoo backup through the web interface can fail due to upload limits or timeout errors.
In such cases, you can restore the database directly using the PostgreSQL command line tools.
1. Create a New Database
Switch to the PostgreSQL user and create a new empty database:
sudo -u postgres createdb new_database_name
2. Unzip the restore file
3. Restore the Database Dump
After creating the empty database, the next step is to import your backup file into it.
If your backup file is a plain SQL file (for example dump.sql), you can restore it using the psql command with input redirection:
sudo -u postgres psql new_database_name < /path/to/dump/dump.sql
4. Restore the Filestore
Locate the extracted filestore from your backup
Example:
ls /opt/backup/V17_COMMUNITY_2025-10-20_07-32-30
#make sure there's "filestore" folder in it
Copy it into Odoo’s data directory:
Example:
sudo cp -r /opt/backup/V17_COMMUNITY_2025-10-20_07-32-30/filestore \
/path/to/your/odoo/local/filestore