Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I want to restore a dumped database. my starting point is a dump_name.sql.tar.gz file
:~$ sudo su - odoo
:~$ createdb [new_db_name]
:~$ tar -xvzf /[path/to/backup/dump_name.sql.tar.gz] | psql [new_db_name]
ERROR syntax error at or near [dump_name]
LINE 1 dump_name.sql # (has an up-arrow under the 'd' of dump_name)
any idea what the problem might be? It's not access rights. The [dump_name] that has been extracted is odoo:odoo & 775
I though I could try separate extractin the .tar file and attach the .sql file to my [new_database]. What would the command be for that
I have seen the commands you fired on the terminal and I have tried it too, It says "Syntax Error".
You are tring to execute two commands in a single line.
Lets make it easy.
CMD 1 : tar -xvzf [path/to/backup/dump_name.sql.tar.gz]
CMD 2 : psql [new_db_name] < [dump_name.sql]
Just try this and let me know it any error occurs.
Just Ignore the Error "role "openerp" does not exist".
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
|Asked: 12/27/14, 8:42 PM|
|Seen: 1688 times|
|Last updated: 3/16/15, 8:10 AM|