Skip to Content
This question has been flagged
2 Replies
17757 Zobrazenia
Avatar
Wiem

Hi,

How can i restore my odoo .dump file (buckup file), How can i import this .dump file to new database ?


Thanks

Avatar
Zrušiť
Avatar
Nikhil Krishnan
Best Answer

Hi Wiem

Please go through the blog, Part 2 will help you.

https://medium.com/@nikhilkrishnan/how-to-restore-your-psql-database-for-odoo-fc7b0bdcfe28

Or go through 

https://www.odoo.com/forum/help-1/question/how-to-setup-a-regular-postgresql-database-backup-4728

Or

https://www.odoo.com/forum/help-1/question/how-can-i-restore-a-dump-backup-file-using-command-line-59885

Thanks

Avatar
Zrušiť
Avatar
Mitul Shingala
Best Answer

Hello,

first create new database using below command in terminal

createdb database_name

now restore the .dump file using below command

pg_restore -c -d [database_name] [dumpfile_name].dump
Avatar
Zrušiť
Samo Arko

I use the method described above or using the database manager "/web/database/manager" and use the restore option, but you also need to have a DB created to restore it to.

I think that the createdb has to be executed in psql and the pgrestore directly in terminal.

Mitul Shingala

yes, you need to execute this command into terminal