Restore from Backup: Should it work to restore backup from system A on system B?
Wednesday, 9 July 2025 · 4 messages · last reply 10 Jul 2025
EK
Eliot Kimber9 Jul 2025 18:05 #
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<https://www.servicenow.com>
LinkedIn<https://www.linkedin.com/company/servicenow> | X<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Instagram<https://www.instagram.com/servicenow>
CG
Christian Grün9 Jul 2025 18:58 #
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
Quoted text · Eliot Kimber · 16 lines
Von: Eliot Kimber via BaseX-Talk <basex-talk at mailman.uni-konstanz.de> Gesendet: Mittwoch, 9. Juli 2025 18:05 An: BaseX <basex-talk at 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<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | X<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Instagram<https://www.instagram.com/servicenow>
EK
Eliot Kimber9 Jul 2025 19:48 #
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
servicenow.com<https://www.servicenow.com>
LinkedIn<https://www.linkedin.com/company/servicenow> | X<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Instagram<https://www.instagram.com/servicenow>
Quoted text · Christian Grün · 32 lines
From: Christian Grün <cg at basex.org> Date: Wednesday, July 9, 2025 at 11:58 AM To: BaseX <basex-talk at mailman.uni-konstanz.de>, Eliot Kimber <eliot.kimber at servicenow.com> Subject: AW: Restore from Backup: Should it work to restore backup from system A on system B? [External Email] 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 O ! This message could be suspicious * Similar name as someone you've contacted. * Someone new is on this email. eliot.kimber at servicenow.com, cg at basex.org recipient(s) added. Provided by ServiceNow DT (Employee Portal KB0077950) - This banner is visible only to ServiceNow employees. CGBANNERINDICATOR 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 at mailman.uni-konstanz.de> Gesendet: Mittwoch, 9. Juli 2025 18:05 An: BaseX <basex-talk at 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<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | X<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Instagram<https://www.instagram.com/servicenow>
EK
Eliot Kimber10 Jul 2025 05:42 #
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
servicenow.com<https://www.servicenow.com>
LinkedIn<https://www.linkedin.com/company/servicenow> | X<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Instagram<https://www.instagram.com/servicenow>
Quoted text · Eliot Kimber · 50 lines
From: Eliot Kimber via BaseX-Talk <basex-talk at mailman.uni-konstanz.de> Date: Wednesday, July 9, 2025 at 5:13 PM To: Christian Grün <cg at basex.org>, BaseX <basex-talk at mailman.uni-konstanz.de> Subject: [basex-talk] Re: Restore from Backup: Should it work to restore backup from system A on system B? [External Email] 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 i This message needs your attention * Someone new is on this email. recipient(s) added. Provided by ServiceNow DT (Employee Portal KB0077950) - This banner is visible only to ServiceNow employees. CGBANNERINDICATOR 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 servicenow.com<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | X<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Instagram<https://www.instagram.com/servicenow> From: Christian Grün <cg at basex.org> Date: Wednesday, July 9, 2025 at 11:58 AM To: BaseX <basex-talk at mailman.uni-konstanz.de>, Eliot Kimber <eliot.kimber at servicenow.com> Subject: AW: Restore from Backup: Should it work to restore backup from system A on system B? [External Email] 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 at mailman.uni-konstanz.de> Gesendet: Mittwoch, 9. Juli 2025 18:05 An: BaseX <basex-talk at 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<https://www.servicenow.com> LinkedIn<https://www.linkedin.com/company/servicenow> | X<https://twitter.com/servicenow> | YouTube<https://www.youtube.com/user/servicenowinc> | Instagram<https://www.instagram.com/servicenow>
Written for BaseX 12.0. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery