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

Question

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.

HELiO Technology, JC · Accepted Answer

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]

MARTINEZ ESTELLES, S.L. · Answer

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.

Sathwik · Answer

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

Donald Leaman · Answer

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.

Relaterede indlæg	Besvarelser	Visninger
Admin password reset not working, tried database, odoo.conf password database admin	2 maj 25	6032
In Odoo, what is the purpose of the PostgreSQL database, and how does Odoo use it? database	0 maj 26	6
Can i use the same Database for a company with different Department database	0 maj 26	61
Database disappeared from list after activating Google Oauth for administrator database	0 jul. 25	4082
Setup Odoo with specific database database	2 nov. 24	11363

Dette spørgsmål er blevet anmeldt

Kan du lide at diskutere? Læs ikke bare med, deltag aktivt i debatten!