[v8] how fix this "syntax error at or near [dump_name]" error when restoring a database

Question

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 extract

Hardikgiri Goswami · Accepted 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

This question has been flagged

Enjoying the discussion? Don't just read, join in!