odoo-database-management.png
Blogger_636313953187816113.jpg
By: Sreejith

Odoo Database Management

How to reliably take a full backup of the database, such that in one operation (or multiple, scriptable via bash), I can restore the database, additional file assets, and installed 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 login screen of odoo.

odoo-database-management-1-cybrosys

Now the user will navigate to database manager screen, here all the databases are listed.

odoo-database-management-2-cybrosys

The user can perform any options.

  1. a) Create
  2. b) Backup
  3. c) Duplicate
  4. d) Restore
  5. e) Drop / Delete 

Creating new 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 login 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

Database Backup

                                               

In certain condition, 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 which creates 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 Zip.

Duplicate a database
In some cases, we need duplicates of some existing databases.

odoo-database-management-6-cybrosys

Click on the Duplicate button

 

Restore the database

 

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

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


odoo-database-management-7-cybrosys

Drop / Delete a 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!




Comments

0


Leave a comment