Odoo 9 Database Backup and Restore

Taking DB backup:

1)      Go to database Manager
2)      Click on backup link in your database
3)      Enter your master password (if you have set Master password).Backup format as: zip (includes filestore)
4)      Extract the downloaded zip file
5)      Your db is now in sql format as dump.sql

Restoring sql format db in new db

1) Create a new db in local with owner selection

2) Go to location

                C:\Program Files\PostgreSQL\9.2\bin -> select psql.exe file

                2.1) (menu)File -> Open commant prompt 

3) Go to comment prompt  and type

   psql.exe  –U db_user db_name < “your sql file location”

4) Enter db_user password

                It data will be start to move from sql format db to your created db.

5) Finally.You can check your data in created db now.