mysqldump in XAMPP: error column-statistics

Problems with the Linux version of XAMPP, questions, comments, and anything related.

mysqldump in XAMPP: error column-statistics

Postby alain.roger » 20. November 2020 20:37

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
What does not kill you, makes you stronger

RogTek, Web agency: htttp://www.rogtek.com
facebook: http://www.facebook.com/rogtek
User avatar
alain.roger
 
Posts: 20
Joined: 03. February 2012 22:14
XAMPP version: 7.4.10
Operating System: Kubuntu 20.04

Re: mysqldump in XAMPP: error column-statistics

Postby alain.roger » 25. November 2020 12:52

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.
What does not kill you, makes you stronger

RogTek, Web agency: htttp://www.rogtek.com
facebook: http://www.facebook.com/rogtek
User avatar
alain.roger
 
Posts: 20
Joined: 03. February 2012 22:14
XAMPP version: 7.4.10
Operating System: Kubuntu 20.04


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 34 guests