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 <[email protected]> Date: Wednesday, July 9, 2025 at 11:58 AM To: BaseX <[email protected]>, Eliot Kimber <[email protected]> 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. [email protected], [email protected] 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 <[email protected]> Gesendet: Mittwoch, 9. Juli 2025 18:05 An: BaseX <[email protected]> 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>
