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> 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 <c...@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.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 <c...@basex.org> Date: Wednesday, July 9, 2025 at 11:58 AM To: BaseX <basex-talk@mailman.uni-konstanz.de>, Eliot Kimber <eliot.kim...@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.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>
