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.comhttps://www.servicenow.com LinkedInhttps://www.linkedin.com/company/servicenow | Xhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Instagramhttps://www.instagram.com/servicenow
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.comhttps://www.servicenow.com
LinkedInhttps://www.linkedin.com/company/servicenow | Xhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Instagramhttps://www.instagram.com/servicenow
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.comhttps://www.servicenow.com LinkedInhttps://www.linkedin.com/company/servicenow | Xhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Instagramhttps://www.instagram.com/servicenow
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? [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@servicenow.com, cg@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@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.comhttps://www.servicenow.com
LinkedInhttps://www.linkedin.com/company/servicenow | Xhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Instagramhttps://www.instagram.com/servicenow
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.comhttps://www.servicenow.com LinkedInhttps://www.linkedin.com/company/servicenow | Xhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Instagramhttps://www.instagram.com/servicenow
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? [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.comhttps://www.servicenow.com LinkedInhttps://www.linkedin.com/company/servicenow | Xhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Instagramhttps://www.instagram.com/servicenow
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? [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@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.comhttps://www.servicenow.com
LinkedInhttps://www.linkedin.com/company/servicenow | Xhttps://twitter.com/servicenow | YouTubehttps://www.youtube.com/user/servicenowinc | Instagramhttps://www.instagram.com/servicenow
basex-talk@mailman.uni-konstanz.de
-
Christian Grün -
Eliot Kimber