Odoo 10 docker export and import data

Question

Hi, I'm currently running odoo 10 in a docker container. I would like to export the data from the one docker and import it in the other one.
On the source system I do the following:
- export the database: pg_dumpall -U postgres | gzip -c > odoo_backup.out.gz
- copy over the directory /var/lib/odoo

On the target I do:
- import the DB dump: psql -U postgres < odoo_backup.out
- copy the odoo directory back to /var/lib/

All works fine, except that the pictures are not visible. When I edit the webs

Axel Mendoza · Accepted Answer

Hi Gregory
Yes, not only the pictures, all the attachments generated and documents are located in the Odoo filestore per database. Normally it's located in the Odoo running user path
~/.local/share/Odoo/filestore But you could have a different place for that setted in the config file as data_dir of your Odoo like the Odoo Docker Image does
data_dir = /var/lib/odoo So if you copy the content of /var/lib/odoo maybe you are having some permissions issues. Set the owner for the odoo user again for t

Dheeraj Balodia · Answer

For backup, you can go to this link  http://localhost:8069/web/database/manager .
You can create a backup from there. You can restore your pre existing backup also.  Important - Before that just set your master password for your Database to avoid consequences in future.

If you want to change particular models or fields while logged in. You can do it by export/importaction provided by Odoo. After exporting data from local you can import it on your server for that you have to validate it.

Jos De Graeve · Answer

Hello Gregory,

I' d recommend to use the odoo database backup feature.  That way you can create a backup containing both the database dump as the attachments file store.

Regards,

相關帖文	回覆	瀏覽次數
Create schedule action For sending emails odoo10	2 7月 25	6850
How to send messages that are not shown in chatter? 已解決 odoo10	2 10月 25	8980
How to ORDER BY? [Odoo 10] 已解決 odoo10	2 11月 24	29901
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) 已解決 odoo10	2 5月 24	8531
Change state of other module odoo10	3 3月 24	7955

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！