mw mysql dump breaking with error

[subnoodle]

Describe the bug

mw database mysql dump mysql_abcdef -o db.sql

  Dumping a MySQL database

  ✅ fetching database. done
  ✅ fetching main user. done
  ✅ fetching project. done
  ✅ creating temporary user. done
  ❌ starting mysqldump via SSH on project p-abcdef. error

     An error occurred during this operation:
     Error: command exited with code 7
     mysqldump: [ERROR] unknown variable 'column-statistics=0'


  ✅ removing temporary user. done
╭──────────────────────────────────────────────────────────────────────────────╮
│ ERROR                                                                        │
│                                                                              │
│ An error occurred while executing this command:                              │
│                                                                              │
│   Error: command exited with code 7                                          │
│   mysqldump: [ERROR] unknown variable 'column-statistics=0'                  │
│                                                                              │
│                                                                              │
│ If you believe this to be a bug, please open an issue at                     │
│ https://github.com/mittwald/cli/issues/new.                                  │
╰──────────────────────────────────────────────────────────────────────────────╯

  ERROR STACK TRACE

  Please provide this when opening a bug report.

  Error: command exited with code 7
  mysqldump: [ERROR] unknown variable 'column-statistics=0'

      at resolve (file:///opt/homebrew/Cellar/mw/1.2.2/libexec/dist/lib/resources/ssh/exec.js:33:25)
      at process.processTicksAndRejections (node:internal/process/task_queues:81:21)

To Reproduce
Steps to reproduce the behavior:

1. Already running mw-project in local ddev
2. see cmd above: mw mysdql dump
3. brings this error
4. sepficed output file is empty after that, so is also the database

Expected behavior
the exported database should be in the speficed dump-file

Console logs
see above

Environment (please complete the following information):

• OS: [e.g. macOS 14]
• Shell Bash PHPStorm / Mac
• Version @mittwald/cli/1.2.2 darwin-arm64 node-v18.20.4

Additional context
Also ddev pull mittwald does not export the dump suceessfully

[martin-helmich]

I could not reproduce this issue with a recent MySQL database. Can you send me some specific project/database with which this issue occurs? (since you're also on the mittwald Slack workspace, feel free to send me any debug information that you want to keep private over there)