Hi Eliot,

I remember that backing up and restoring databases might result in surprises if you work with different operating systems (due to the different case sensitivity handling). If you use both a UNIX-based and a Windows system, it might help to run a subsequent OPTIMIZE or OPTIMIZE ALL.

Hope this hels,
Christian


Von: Eliot Kimber via BaseX-Talk <basex-talk@mailman.uni-konstanz.de>
Gesendet: Mittwoch, 9. Juli 2025 18:05
An: BaseX <basex-talk@mailman.uni-konstanz.de>
Betreff: [basex-talk] Restore from Backup: Should it work to restore backup from system A on system B?
 

Using BaseX 11.6 on RHEL 9, I created a backup of a database on system A, copied the zip to my personal machine, then used the DBA upload and restore to recreate the database on the new server. I verified that the Zip has the expected data files, so it looks legit.

 

The database is created but no data is loaded, so the database shows 0 bytes.

 

Should this load have worked?

 

I can also just scp the database from one server to the other if that is reliable, or just unzip the zip on the target server—should that work?

 

Cheers,

 

E.

 

_____________________________________________

Eliot Kimber

Sr. Staff Content Engineer

O: 512 554 9368

 

servicenow

 

servicenow.com

LinkedIn | X | YouTube | Instagram