Skip to Content
This question has been flagged
filestorerestoredbpsqlOdoo18.0
1 Respondre
3511 Vistes
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
Descartar
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
Descartar
Related Posts Respostes Vistes Activitat
Backup/Restoring a Large Database using PSQL dump with Filestore? Solved
filestore backup restoredb ir_attachment psql
Avatar
Avatar
Avatar
Avatar
Avatar
26
d’oct. 25
65586
"Command `psql` not found" after Odoo9 [community] restore on Windows 7
postgresql windows7 restoredb psql
Avatar
0
de des. 16
6485
[SOLVED]Error while opening preferences
filestore postgresql preferences restoredb
Avatar
Avatar
Avatar
2
de juny 16
7520
Deneutralizing a production database after restore in odoo.sh Solved
database restoredb databasebackup odoo.sh Odoo18.0
Avatar
Avatar
Avatar
2
de jul. 25
1783
Odoo 10 : backup and restore Solved
filestore backup restore restoredb odoo10
Avatar
Avatar
Avatar
5
de març 24
32651