Odoo Help


12 Answers
Franz Palfrader
9/2/14, 11:20 AM

On the local Server do this

# sudo su odoo (your user)
# dropdb database_name
# createdb database_name
# cd /to/your/dump/path
# psql -f dump.sql database_name

Copy the filestore content, on my server /opt/odoo/.local/share/Odoo/filestore/database_name


Roberto Barreiro
12/3/14, 7:30 AM

If you are working on linux, and if it can be of your interest, I have made 2 scripts, the first to make backup, and the other one to restoring.

The backup script can be combined with cron to make schudeled backups for a default database, or whatever database you want. This backup script creates a compressed backup with a name compound by the database name and the date of the backup. Also it creates (or overwrites) a backup file called yourdb_last_backup, wich is very comfortable to use with the restore script. Using the restore script without parameters, restores the last backup, or you can restore your desired file indicating it as parameter.

Other interesting functions of these scripts are addons backup, and autodelete backups older than the days of your choice.

If you would like to try these scripts contact me. I hope it helps.

Disgal Milladoiro, S.L., Roberto Barreiro
12/3/14, 10:04 AM

Scripts sended. Enjoy them :)

Kitsikpui Elliot Elikplim
12/4/14, 4:47 AM

Can you please mail me your scripts ekitsikpui5@me.com

Disgal Milladoiro, S.L., Roberto Barreiro
4/20/15, 6:34 AM

if anyone is interested in these scripts, I uploaded them to github: https://github.com/roberto-barreiro/odoo_backup_scripts

Elikplim Elliot Kitsikpui
4/20/15, 6:36 AM
Thank you. Just when I needed it: )
On Apr 20, 2015, at 10:34 AM, Roberto Barreiro <roberto-disgal.es@mail.odoo.com> wrote:

if anyone is interested in these scripts, I uploaded them to github: https://github.com/roberto-barreiro/odoo_backup_scripts

Roberto Barreiro
Sent by Odoo S.A. using Odoo about Forum Post False

Yves Goldberg
12/2/14, 1:00 PM


Michael Bos
9/3/14, 3:15 AM

You can do what Franz says but you can also do this all in one command.

You dump the database and pipe it directly into another one.

sudo -u postgresql pg_dump -h host1 dbname | psql -h host2 dbname (pg_dump -h host1 dbname | psql -h host2 dbname is taken directly from the PostgreSQL documentation)

So Let's say you have:

host1: openerp.example.com with username openerp

dbname host1: openerp

host2 : local (so leave this blank because it will go for localhost when nothing is mentioned)

dbname host2: whatever you like.

You will use

pg_dump -h openerp.example.nl "dbname" | psql "dbname"


Good luck!


5/7/15, 1:33 PM

How can id do the backup.  

i also don´t know where is  "control centre."

12/21/14, 11:52 AM

Hi Franz how can I get the scripts?
I would like to set it in the crontab.


Laurent ROCHE
12/21/14, 11:34 AM

@David Searle :

Where do I find the control center ? What is the menu to use ?

I could not find any where a command to export data from the database ! ? !

Any help would be apreciated !

Dominique Chabord
12/4/14, 12:56 PM


you have first to ask Odoo about the version running your saas service and build the same.

Then do the restoration of the sql file as explained.

If your server is compatible with the database, you should succeed in starting your server with the --update option and check the log. If this test fails,your server is likely to be uncompatible. For example, it doesn't work with a standard V8.0.


Ask a Question
Keep Informed
6 follower(s)
About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

Odoo Training Center

Access to our eLearning platform and experience all Odoo Apps through learning videos, use cases and quizzes.

Test it now