Skip to Content
This question has been flagged
filestorerestoredbpsqlOdoo18.0
1 Reply
3732 Views
Avatar
Muhammed Fasil

I have restored an Odoo database from a .dump file, but the filestore is missing. As a result, attachments and some file-dependent functionalities are not working correctly.

Could someone guide me on the proper steps to recreate the filestore from the .dump file? Specifically, I’d like to know:

  1. Can the filestore be regenerated from the database?
  2. If not, what are the best practices for restoring or handling the missing filestore in such scenarios?

Any help or documentation references would be greatly appreciated.

Thank you in advance!

Avatar
Discard
Fredy

Hola estimado, ya se arregló tu problema?

Avatar
Nguyen Anh Tuan
Best Answer

Unfortunately, the filestore cannot be regenerated from the .dump file alone, because the .dump only backup the database, and Odoo stores binary attachments (e.g., uploaded files, images) outside the database in the filestore directory located under: 

~/.local/share/Odoo/filestore/<dbname>/

so in the case you backup using the dump file it will not include the attachment file there, thefore you cannot get the attachment file when you restore it.

what you can do: 

before you restore, you should create a backup copy of your filestore directory in 

~/.local/share/Odoo/filestore/<dbname>/

then after you restore it the filestore directory will be replace with the empty filestore directory, you will then copy the filestore backup folder over the filestore folder and make sure it have proper user:group access 

in the future, you should consider to create backup with .zip instead of .dump or if you want to backup using dump database you will have to backup the filestore separately

regard, 

Tuan 

https://skyerp.net

Avatar
Discard
Related Posts Replies Views Activity
Backup/Restoring a Large Database using PSQL dump with Filestore? Solved
filestore backup restoredb ir_attachment psql
Avatar
Avatar
Avatar
Avatar
Avatar
26
Oct 25
66056
"Command `psql` not found" after Odoo9 [community] restore on Windows 7
postgresql windows7 restoredb psql
Avatar
0
Dec 16
6580
[SOLVED]Error while opening preferences
filestore postgresql preferences restoredb
Avatar
Avatar
Avatar
2
Jun 16
7636
Deneutralizing a production database after restore in odoo.sh Solved
database restoredb databasebackup odoo.sh Odoo18.0
Avatar
Avatar
Avatar
2
Jul 25
2002
Odoo 10 : backup and restore Solved
filestore backup restore restoredb odoo10
Avatar
Avatar
Avatar
5
Mar 24
32784