Skip to content

mw mysql dump breaking with error #930

@subnoodle

Description

@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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions