Bug 28471 - koha-dump --schema-only does not work with mysqldump 8
Summary: koha-dump --schema-only does not work with mysqldump 8
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
Depends on: 26947
  Show dependency treegraph
Reported: 2021-05-27 10:13 UTC by Jonathan Druart
Modified: 2023-07-01 09:47 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Druart 2021-05-27 10:13:00 UTC
With focal

  mysqldump: Couldn't execute 'SELECT COLUMN_NAME,                       JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"')                FROM information_schema.COLUMN_STATISTICS                WHERE SCHEMA_NAME = 'koha_kohadev' AND TABLE_NAME = 'account_credit_types';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109)

But adding --column-statistics=0 (like suggested over the web) will break the command when run with a lower version

  mysqldump: unknown variable 'column-statistics=0'
Comment 1 Katrin Fischer 2023-07-01 09:47:02 UTC
Hm, the versions here are quite old now - can we tell if this is still a problem?