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,

Gerelateerde posts	Antwoorden	Weergaven
Create schedule action For sending emails odoo10	2 jul. 25	6812
How to send messages that are not shown in chatter? Opgelost odoo10	2 okt. 25	8943
How to ORDER BY? [Odoo 10] Opgelost odoo10	2 nov. 24	29890
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) Opgelost odoo10	2 mei 24	8521
Change state of other module odoo10	3 mrt. 24	7946

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!