Upgrading a old Etherpad Lite instance

[chriscroome]

I have an old Etherpad Lite instance I need to migrate and upgrade and it appears that the instance doesn't use a external database, I have these database files:

ls -lah var/*.db
-rw-r--r-- 1 etherpad etherpad 1.1K Apr  7  2022 var/dirty.db
-rw-r--r-- 1 etherpad etherpad  58G Jun 16 13:34 var/old.db

It is the tiny dirty.db one that is referenced by settings.json:

grep -r "\.db" settings.json
    "filename": "${DB_FILENAME:var/dirty.db}",

I see that there is a migrateDirtyDBtoRealDB.ts script, I'm hoping to use this to import the var/old.db file into a MariaDB database using the latest version of the code base, I'm also wondering if I should used the old code base migrateDirtyDBtoRealDB.js script rather than the new migrateDirtyDBtoRealDB.ts one as I've not been able to work out how to run it, the file contains:

  // This script requires that you have modified your settings.json file
  // to work with a real database.  Please make a backup of your dirty.db
  // file before using this script, just to be safe.
  // It might be necessary to run the script using more memory:
  // `node --max-old-space-size=4096 src/bin/migrateDirtyDBtoRealDB.js`

I have added the MariaDB details to settings.json in the new code base and also copied the two .db files and this is what I have tried:

node bin/migrateDirtyDBtoRealDB.ts 
node:internal/modules/esm/get_format:219
  throw new ERR_UNKNOWN_FILE_EXTENSION(ext, filepath);
        ^

TypeError [ERR_UNKNOWN_FILE_EXTENSION]: Unknown file extension ".ts" for /home/etherpad/sites/etherpad/bin/migrateDirtyDBtoRealDB.ts
    at Object.getFileProtocolModuleFormat [as file:] (node:internal/modules/esm/get_format:219:9)
    at defaultGetFormat (node:internal/modules/esm/get_format:245:36)
    at defaultLoad (node:internal/modules/esm/load:120:22)
    at async ModuleLoader.loadAndTranslate (node:internal/modules/esm/loader:580:32)
    at async ModuleJob._link (node:internal/modules/esm/module_job:116:19) {
  code: 'ERR_UNKNOWN_FILE_EXTENSION'
}

Node.js v22.16.0

I have also tried copying this file to bin/migrateDirtyDBtoRealDB.js but that doesn't seem to help:

node bin/migrateDirtyDBtoRealDB.js 
file:///home/etherpad/sites/etherpad/bin/migrateDirtyDBtoRealDB.js:39
  const p: Promise<void>[] = [];
        ^

SyntaxError: Missing initializer in const declaration
    at compileSourceTextModule (node:internal/modules/esm/utils:344:16)
    at ModuleLoader.moduleStrategy (node:internal/modules/esm/translators:105:18)
    at #translate (node:internal/modules/esm/loader:534:12)
    at ModuleLoader.loadAndTranslate (node:internal/modules/esm/loader:581:27)
    at async ModuleJob._link (node:internal/modules/esm/module_job:116:19)

Node.js v22.16.0

Does anyone have any suggestions for me? Thanks!