Page 1 of 1

mysqldump in XAMPP: error column-statistics

PostPosted: 20. November 2020 20:37
by alain.roger
Hi,

i use under Ubuntu Xampp 7.4.10 and i'm trying to my mysqldump work.
when i run it, I get /opt/lampp/bin/mysqldump: unknown variable 'column-statistics=0'

i added column-statistics=0 in my.cnf but without any difference. I tried also to add --column-statistics=0 in mysqldump command line but both raise the same issue.

any idea how to solve that issue because i did not find any mysqldump.cnf file.

thx

Re: mysqldump in XAMPP: error column-statistics

PostPosted: 25. November 2020 12:52
by alain.roger
So here is the solution:
- XAMPP 7.4x use MariaDB and therefore the MySQL issue with column-statisctics under MySQLDump of MariaDB 10.x does not exist. Therefore there is no need to setup my my.cnf {Mysqldump} a line with column-statistics=0

it works without this option.