Mysqldump doesn't work anymore

Off-Topic
1

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?

Thanks

2

Which version of MySQLDump?

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

-Adam

3

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

4

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

5

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