Skip to Content
This question has been flagged
5 Replies
17554 Views
Avatar
Randy Ong

HI I'm using odoo for a trial (2 users - online) and would like to know if I can export my data to my own odoo server installation.

including setting/modules and data information ? 

Is there any restrictions?

Avatar
Discard
Avatar
Fabien Pinckaers (fp)
Best Answer

Yes, you can download your database from the control center and install it on premise.

Avatar
Discard
David Searle

Can you explain how to achieve this? My backup from the control centre is in the format .zip and extracts to a filestore folder and .sql file. There is no way of restoring through pgadmin or the local pc manage database interface

Avatar
Dieter Huelskamp
Best Answer


This seems not to be the case for me here and now. When you register your free trial on odoo.com. If I go to my account, I get option to choose the registered company or to create a new one. The registered free company has an arrow down, where one of the the options is "download backup". If you click there ,it says something like, that my odoo.com user is not admin, so it seems you cannot do this operation by your own. Please correct me, if I am wrong. Also adding  /database/manager to url  just throws a 404 on odoo.com quick-start-instances.  (also compare this screenshot)

I also read this thread dealing about same topic, but I get forbidden on the suggested url:

https://www.odoo.com/forum/help-1/question/where-is-the-control-center-how-to-get-a-backup-of-my-database-solved-68631

Avatar
Discard
Jérémy Kersten (jke)

You need to be connected as administrator into the database that you want the backup ! Let us know if it if ok ...

Avatar
gunnar
Best Answer

I think that basically requires 2 steps.

  1. backup your online database (logout from your Odoo > manage databases > backup
  2. restore the database in you on-premise installation > manage database > restore

I haven't done that ever, so I am not sure what problems might occur. I guess it is important that your on premise installation has the same modules installed as your online version.

There will be other ways to do that with PostgreSQL tools as well.

Avatar
Discard
David Searle

I am trying to do the same from odoo.com to a local serverbut my database backup is a xxxx.zip file and extracts to a filestore directory and sql file which I cannot then restore in my local pgadmin

Mark Lewis

I am trying to do this as well but odoo themselves say that its not so simple due to different modules.

I tried and it did not work.

I resolved to export data to excel or FEC file and then to local.

Not managed it yet though.

I found an import module but its buggy.

If anyone has a good method please help