How to Create a Backup of Your Odoo Database

Effectively managing your OpenERP/Odoo database includes regularly backing it up to safeguard your valuable data. This guide provides a straightforward process to create a backup of your Odoo database. To begin, navigate to the "Manage Database" section, which displays all available databases.

Upon clicking, you will be directed to the Database Manager screen, where you can oversee and interact with your various Odoo instances.

On the Database Manager screen, locate and click the "Backup" option situated in the left-hand panel. This action will take you to the Backup Database screen. Here, you will need to select the specific database you wish to back up and then securely enter your "master password." Once these details are provided, click the "Backup" button to initiate the download of your database backup.

Following the confirmation of your details and clicking "Backup," the database dump will be promptly downloaded to your local system, ready for storage or further use.

How to Restore a Database in Odoo

Once you have a database backup, you have the flexibility to restore it, either to its original state or as a new database on your Odoo server. Follow these precise steps to restore your database:

1. Click on the "Restore" option located in the left-hand panel. This will direct you to the Restore Database screen, where you can begin the restoration process.
2. Click the "Choose Files" button next to the "File" field. Browse your system to select the database dump file that you previously saved.
3. In the "New Database Name" field, provide a unique and descriptive name for the restored database. This is crucial if you are restoring it as a new instance.
4. Enter the "Master Password" for your Odoo server to authorize the restoration. Finally, click the "Restore" button to complete the process and bring your database back online.

With these steps completed, your database is now successfully restored on the Odoo server. You can proceed to access the database by logging in with the appropriate credentials.