Enable Dark Mode!
odoo-database-management.png
By: Sreejith

What is Odoo Database Management?

Functional

How to take a complete backup of the database reliably, like that in one operation (or multiple, scriptable via bash), I can restore the database, additional file assets, and install modules to a new server.

Let’s go step by step process


First, we need to load odoo on the browser. Here I am taking as localhost. Type the URL as

localhost:8069/web/database/manager

Or

Click on the manage database from the login screen of odoo.


odoo-database-management-1-cybrosys

Now the user will navigate to odoo database manager screen, where all the databases are listed

odoo-database-management-2-cybrosys

The user can perform any options in the Odoo database.

1.Create

2.Backup

3.Duplicate

4.Restore

5.Drop / Delete 


How to Create a new Odoo database?


odoo-database-management-3-cybrosys


Here we are given the database name. You can see the Email and Password there. Why this email and Password? Well, this is for login credentials. By using this Email and Password we can log in to our database. This will be the administrative account for our odoo. We can choose our language. When we select a country, the Accounting Package will be installed for that country.


There is a checkbox called Load Demonstration data if you tick this option the demo data will be loaded for each module(customers, suppliers, SO’s, PO’s, Employees a,d users, etc...).

And Click on continue after a while odoo will redirect to odoo Apps. And we can start using odoo.


odoo-database-management-4-cybrosys

How to Create Odoo Database Backup?  

                        

In certain conditions, we need a copy of the database for future needs, for that we are keeping a backup of the database. There is a custom module that creates the database backup

In order to take the backup of a database click on the Backup button of the corresponding Database.


odoo-database-management-5-cybrosys

Select the Backup format and click on Backup Button. Here we are selecting the Backup format as zipping.

How to Duplicate Odoo database?
 
In some cases, we need duplicates of some existing databases.

odoo-database-management-6-cybrosys

Click on the Duplicate button

 

How to Restore odoo database?


Select the database you already have (backup) and give a name for the database.

The name database will not be the same as you have in reserve (backup) the name will be the one you give here.


odoo-database-management-7-cybrosys

How to Drop / Delete Odoo database?

It is very easy to delete an unwanted database

odoo-database-management-8-cybrosys

Just click on the delete button from the database manager then a window will pop up and click on the delete. It is done!


If you need any assistance in odoo, we are online, please chat with us.



4
Comments

venkatram

how to backup the deleted database in odoo if it is possible or not

29/03/2018

-

12:57AM

venkatram

how to restore the deleted db in odoo

29/03/2018

-

12:03AM

sehrish

thanks for sharing your knowledge

26/04/2018

-

12:24AM

Nivas

Is it possible to recover drop database in odoo?

11/01/2020

-

12:10AM



Leave a comment

 


whatsapp
location

Calicut

Cybrosys Technologies Pvt. Ltd.
Neospace, Kinfra Techno Park
Kakkancherry, Calicut
Kerala, India - 673635

location

Kochi

Cybrosys Technologies Pvt. Ltd.
1st Floor, Thapasya Building,
Infopark, Kakkanad,
Kochi, India - 682030.

location

Bangalore

Cybrosys Techno Solutions
The Estate, 8th Floor,
Dickenson Road,
Bangalore, India - 560042

Send Us A Message