I have read all the other similar questions regarding this issue, and the most recent one is 7 years old so none of the version or the links provided have been helpful to me.
I am using XAMPP (Control Panel v3.3.0, compiled Apr 6th, 2021) which apparently uses MariaDB version 10.4.19-MariaDB - mariadb.org binary distribution.
Until recently, MySQL Workbench worked well with my local version of MariaDB (and the version that is installed on the web (which is apparently 10.3.36-MariaDB). But now I'm trying to export and I get the following message: mysqldump.exe is version 8.0.30 but the MySQL Server to be dumped has version 10.3.36. It is recommended you upgrade or downgrade your local MySQL client programs, including mysqldump to a version equal to or newer than that of the target server.
I cannot downgrade my MariaDB version to 8, and MySQL Workbench is the newest one available (I just downloaded and installed the newest one hoping it would solve the problem). But I still get the same problem. When I try to export I get this error message:
Couldn't execute 'SELECT COLUMN_NAME, JSON_EXTRACT(HISTOGRAM, '$."number-of-buckets-specified"') FROM information_schema.COLUMN_STATISTICS WHERE SCHEMA_NAME = 'MySchemaName' AND TABLE_NAME = 'FirstTableInList';': Unknown table 'COLUMN_STATISTICS' in information_schema (1109) Operation failed with exitcode 2
Would someone be willing to try and help me out? What shall I try next?
I am not very technical, so please don't assume I have any background knowledge in any of these technologies. I would need very specific instructions.
Thank you in advance
CJ