This question has been flagged
1 Reply
5856 Views

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

Avatar
Discard
Best Answer

Dear Gunnar,

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".

Best Wishes,
Hardik

Avatar
Discard
Author

separating tar & psql commands did work, thanks

Hello Gunnar, Please up vote for the answer.