Odoo Help

0

How do I copy my database(s) to a different computer?

By
Donald Leaman
on 1/20/14, 2:33 PM 4,722 views

Anyone have a step-by-step procedure so I can copy my database(s) to a different computer? I tried to use PostgresSQL PGAdmin method but it gives me an error saying it's an invalid file. I can't see exactly how to do it using the tools within Openerp. I think this would be the better method if it were possible, but ANY method that works would be appreciated. Thank you for being helpful.

Someone with karma please close?

Donald Leaman
on 4/22/17, 1:18 PM
1
JC
On 1/20/14, 7:41 PM

Backup databases:
1. openerp login screen click [Manage Databases]
2. under Database Management click [Backup]
3. choose your database / password ( default admin) then click on [Backup]

Copy all database backup files to new computer

Restore databases:
1. openerp login screen click [Manage Databases]
2. under Database Management click [Restore]
3. choose your database file / enter password ( default admin) name your database then click on [Restore]

When you say « Copy all database backup files to new computer », which files are you talking about? Can you give me a path? Thanks

Pascal Tremblay
on 10/8/14, 7:37 AM
0
Sathwik
On 1/27/17, 9:15 AM

Hi I tried the procedure mentioned above for restoring from a ubuntu server system to another ubuntu backup system but it shows error I am unable to restore backup taken from server.

can any one help in guiding me to restore the data

I am using odoo 9.0 on a ubuntu server 16.0.1

any help would be thankfull.

sorry I don't have enough karma to comment so I am posting here

0
Donald Leaman
On 6/26/14, 9:14 PM

Thank you very much.  I was successful.

 

I can't see how to close this question, so if any board admin will do it thank you very much.

0
Francisco Martínez
On 3/12/14, 7:56 AM

If you have a problem with "database manager" method, you can try with this:

  • DUMP DataBase from source server:

    pg_dump -f oe-mydatabase_backup.sql mydatabase_name

  • RESTORE on destination server:

    psql -f mydatabase_backup.sql mydatabase_name

You need remember if have a custom addons then need copy the server files.

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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)

Stats

Asked: 1/20/14, 2:33 PM
Seen: 4722 times
Last updated: 1/27/17, 9:15 AM