Odoo Help

Welcome!

This community 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.

1

Is it possible to migrate our database from the cloud to an in-house installation?

By
Fred Blauer
on 6/16/15, 3:51 PM 684 views

I did a search and I couldn't seem to find any information on this. Is it possible to backup our database locally or to a cloud drive like dropbox? And is it possible to restore a backup copy of our database to a local in-house installation of the software?

2
Şaban Yıldız
On 6/17/15, 2:54 AM

First you have to take the back up your database, after you install a new odoo, you will upload the database on your local host. To do this, just visit http://localhost/web/database/manager

I was able to backup the database, but not able to restore it into a postgresql server. It produced a file called dump.sql. I tried using restore, which didn't recognize the backup. Then I tried importing and running the sql script which produced errors. What is the proper way to restore this backup.

FBA, Fred Blauer
on 6/17/15, 9:17 AM

Did you set up a new odoo on your local host?

Şaban Yıldız
on 6/17/15, 9:25 AM

First I tried restoring to a PG server. I couldn't get that to work. Then I did a full installation of Odoo, and tried various different ways of restoring, such as installing on top of a blank database created in Odoo etc. All of them gave me errors. Is there a proper way of doing the restore?

FBA, Fred Blauer
on 6/17/15, 6:14 PM
0
Fred Blauer
On 6/18/15, 11:39 AM

I had some initial problems backing up, but now it seems to work. Its kind of tricky. You have to be logged into the database, then go to account, then manage organizations, then it will let you backup to a zip file. To restore the .zip file, you can go into the database management of the in-house install and use the restore in there (don't unzip the file file dump, and don't use a posgresql db mgmt tool - only use the Odoo database mgmt, restore function which creates a new database). It seemed to restore successfully but you have to login using your odoo account, and not the user email address. It seems to work ok, but now I have a message on the top of my screen - "could not get content for /saas/trial/static/css/demo.css defined in bundle 'web.assets_backend" Would really like to know how to get rid of that message. 

0
Francesco Faleschini
On 6/17/15, 4:11 AM

Your question's subject says " from the cloud to an in-house installation", in the description you mention "backup our database locally or to a cloud drive". 

It is not clear where your database is. If you are using Odoo's SaaS you'd better contact Odoo SA, anyway Odoo's backup is mainy Postgres backup, so once you are able to take a backup it is a file and you can save it wherever you like (local drive, cloud drive, ...).

About the second question: " is it possible to restore a backup copy of our database to a local in-house installation of the software? "

the Answer given by Şaban Yıldız is perfect.

My database is in the Odoo SAAS/cloud system. I was able to back it up from the manage companies screen, but was not able to restore it. It created a file called dump.sql, which I wasn't able to restore to a postgresql 9.3 server. I am just trying to test the process to make sure that it can be done as an assurance measure.

FBA, Fred Blauer
on 6/17/15, 9:24 AM

AS far as i know Odoo SaaS use a custom version of odoo (in fact on github you see many branches for saas), so i am not sure you can install a backup from the saas version into a standard v8 installation. You should ask them, likely at least some minimum db fine tuning work is necessary, but i guess the procedure is not automatic or straightforward in your case.

Nord Est Systems srl, Francesco Faleschini
on 6/18/15, 5:42 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 6/16/15, 3:51 PM
Seen: 684 times
Last updated: 6/18/15, 11:39 AM