Mysqldump doesn't work anymore

Hi SingleStore,

The mysqldump command returns the following error when trying to export data:
mysqldump: Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'mindsdb' AND TABLE_NAME = 'commands';': Function 'mindsdb.JSON_EXTRACT' is not defined (1128)

Any idea how to solve this please?


Which version of MySQLDump?

Now and then the MySQL folks add new queries to MySQLDump that we need to adapt to.


It is mysqldump Ver 8.0.21, which version is still compatible please?

Found out that the only mysqldump that works comes from MariaDB 10 and not MySQL 8.

Thanks Pierre,

I opened an internal task to track fixing our compatibility with mysqldump Ver 8.

We add JSON support before MySQL did so our JSON syntax is not 100% capable with theirs (and it now looks like newer MySQLDump is hitting a case where the JSON syntax is incompatible).

1 Like