Nevermind—I’m an idiot. I was expecting the upload action to do the restore, but of course you first upload a backup and then you separately do the restore action.
All good now.
Cheers,
E.
_____________________________________________
Eliot Kimber
Sr. Staff Content Engineer
O: 512 554 9368
servicenow
LinkedIn | X | YouTube | Instagram
From:
Eliot Kimber via BaseX-Talk <basex-talk@mailman.uni-konstanz.de>
Date: Wednesday, July 9, 2025 at 5:13 PM
To: Christian Grün <cg@basex.org>, BaseX <basex-talk@mailman.uni-konstanz.de>
Subject: [basex-talk] Re: Restore from Backup: Should it work to restore backup from system A on system B?
Both server A and server B are Linux machines—my personal machine is just the carrier for the Zip.
When I try to optimize the database I get a runtime failure:
Stopped at /data/basex/webapp/dba/databases/db-optimize.xqm, 104/10:
[basex:restxq] Value of "name" must be xs:string, supplied: ().
The database shows 0 items but a size of 61 MB.
The database I’m attempting to migrate to the new server shows 8 items and 196 MB, so it’s possible something went wrong in the creation of the backup, or maybe I just didn’t wait long enough…
Cheers,
E.
_____________________________________________
Eliot Kimber
Sr. Staff Content Engineer
O: 512 554 9368
servicenow
LinkedIn | X | YouTube | Instagram
From:
Christian Grün <cg@basex.org>
Date: Wednesday, July 9, 2025 at 11:58 AM
To: BaseX <basex-talk@mailman.uni-konstanz.de>, Eliot Kimber <eliot.kimber@servicenow.com>
Subject: AW: Restore from Backup: Should it work to restore backup from system A on system B?
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