Skip to Content
This question has been flagged
restore
2 Replies
1653 Views
Avatar
Santiago Carbonell Forment
I'm trying to migrate a Odoo16 to Odoo17 database using OpenUpgrade and its working fine, but the attached pdf in invoice sales are lost. I though that when you migrate, you always lose that attached file and if you delete from the invoice sales and recreate a new one and it's working but I've realized that the problem is with the restored database:

When I backup my database from Odoo16 from the UI using the complete zip is 317Mb. Then, I restore that database and migrate using OpenUpgrade and if then try to rebackup from Odoo17 from the UI using the same complete zip is 71Mb, so where is the space?

I think the problem is when I try to restore the backup from Odoo16 in Odoo17. If I check the space of database filestore and I see that Odoo17 is smallest than the Odoo16 in /home/odoo/.local/share/Odoo/filestore, so something I'm doing wrong in backup and restore using the UI. All both OS has enought space in the disk

I understand, I cannot restore the database in Odoo17 and then copy/paste the same filestore from Odoo16 to Odoo17 and that is a bad practice

What is the right way of restoring an Odoo database? or Why the UI is not restoring in the right way the filestore of the database? Can you help me?

In case it helps, when I restore my client's database from their Odoo16 to my Odoo16, initially from the UI, the whole process is correct and the space in the filestore matches the backup zip file 317Mb.

Thanks

Avatar
Discard
Avatar
CandidRoot Solutions
Best Answer

Hello Santiago,

I hope you are doing great.

You have correctly identified that the Filestore (PDFs and attachments) is missing, which explains why the backup size dropped from 317Mb to 71Mb.

The Root Cause: The issue is in this step: "I restore that database [Odoo 16] using the Odoo 17 UI." The "Restore" button in Odoo 17 is designed to accept Odoo 17 backups. When you force an Odoo 16 backup into it, the system often accepts the data (SQL) but fails to correctly unpack the filestore (attachments) because the version signature doesn't match, resulting in data loss.

Clarification on "Bad Practice": You mentioned that "copy/pasting the filestore is bad practice." Actually, for OpenUpgrade migration, manually moving the filestore is the correct and required procedure. The migration script only updates the database structure; it assumes the files are already sitting in the correct folder.

The Correct Steps to Fix This:

  1. Do not use the Odoo 17 UI to restore.

  2. Extract your Odoo 16 Zip file manually on your computer. You will see a filestore folder and a dump.sql file.

  3. Restore the SQL: Load the dump.sql into the database using the command line.

  4. Move the Files: Copy the extracted filestore folder into your Odoo 17 filestore location manually.

  5. Run OpenUpgrade: Now run the migration script.

Since the files (PDFs) are physically there before the migration starts, Odoo 17 will successfully link to them, and your invoices will be perfect.

Thanks & Regards 

CandidRoot Solutions Pvt. Ltd.
Mobile: (+91) 8849036209
Whatapp: (+91) 8849036209

Email: info@candidroot.com
Web: https://www.candidroot.com

Avatar
Discard
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer
Hi,

In Odoo, invoice PDFs are stored in the filestore, not in PostgreSQL, and the database only contains references to those files (ir_attachment).
Restoring an Odoo 16 backup directly into Odoo 17 using the UI is not safe; the UI restore process is only reliable when restoring into the same major version, which is why the filestore ends up much smaller.
OpenUpgrade does not delete or drop attachments; it reuses the existing filestore during the migration.
The missing PDFs appear because the filestore was never fully restored, not because the migration removed them; recreating invoices works because new PDFs are generated.
Manually copying the filestore from Odoo 16 to Odoo 17 after restoring the database is bad practice and can break attachment references.
The correct approach is to restore the backup in Odoo 16 first (verifying the filestore size matches the backup) and only then run OpenUpgrade to migrate the database to Odoo 17.

Hope it helps.

Avatar
Discard
Related Posts Replies Views Activity
The following modules are needed by other modules but have not been defined,
restore
Avatar
1
Feb 25
88
Accident how to restore remove from view
restore
Avatar
Avatar
1
Nov 24
3453
Restore database from flat files only
restore
Avatar
Avatar
1
Apr 24
3392
Howto fully restore a database? (odoo.sh v13) Solved
restore
Avatar
1
Aug 20
9751
How to Restore and override the same database from its own backup file
restore
Avatar
Avatar
Avatar
Avatar
4
Feb 18
11120