This question has been flagged
4 Replies
6637 Views
restore
Avatar
gain charlie

I have an existing register database call SAHARA (odoo 10 enterprise with 6 users)
I plan to import customer mater records from excel.
To safeguard the existing database, i made a backup.
 i would like to test the backup file integrity, so i try performing RESTORE DATABASE function
to override the existing register database. 
But the only option i have is 


Odoo system suggest the following:In order to avoid conflicts between databases, Odoo needs to know if this database was moved or copied. If you don't know, answer "This database is a copy".
But i got bump to this error prompt.
Please Help!
Avatar
Discard
Niyas Raphy (Walnut IT)

HI, in my opinion you just select the "This Database is a copy".

For to know further difference between the both just refer this, there is a little info about this,

https://www.odoo.com/zh_CN/forum/help-1/question/restore-vs-copy-of-an-existing-database-58690

Avatar
James T
Best Answer

If you want to override your current database with a backup of it, you need to:

0. create a backup of your database via the manager URL: http://localhost:8069/database/manager or whatever domain and port number you use for Odoo.

1. delete the current database using the manager

2. restore the database using the backup, and giving it the same name


Note: Odoo won't allow databases with the same name even if a different SQL ROLE owns it as this is a rule in PostgreSQL. Two databases can not have the same name.

Avatar
Discard
Avatar
alanz
Best Answer
In such cases you can use recovery software, for example Disk Drill at [https://www.cleverfiles.com/mac-mini-hard-drive-recovery.html]. I always use it when I need to recover any deleted files. Hope it will help you too.
Avatar
Discard
Avatar
Rishan Malaka
Best Answer

Use This database is copy.then you can restore the backup DB as a copy of original one.then you can use that to your testing things and if it is success, you can do same thing for your original DB and delete the backup DB. that's the best way to solve your problems.

Avatar
Discard