Odoo Help

0

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

By
Donald Leaman
on 1/20/14, 2:33 PM 3,453 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.

1

JC

--JC--
819
| 5 1 8
Kuala Lumpur, Malaysia
--JC--

 

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: 3453 times
Last updated: 1/27/17, 9:15 AM