[mythtv-users] backup script failing

[Tim Draper]

 ---- On Sat, 25 Apr 2020 14:32:31 +0100 Nick Morrott <knowledgejunkie at gmail.com> wrote ----
 > This is due to a new flag that is enabled by default in mysqldump 8.
 > You can disable it by adding --column-statistics=0. The command will
 > be something like:
 > 
 >   mysqldump --column-statistics=0 --host=<server> --user=<user>
 > --password=<password>
 > 
 > To disable column statistics by default, you can add
 > 
 > [mysqldump]
 > column-statistics=0
 > 
 > to a MySQL config file, such as /etc/my.cnf or ~/.my.cnf.
 > 
 > Cheers,
 > Nick

any other solutions? either mythtv devs need to tweak the backup scripts (mythconverg_backup.pl) to exclude column stats in the mysqldump cmd (I've taken a quick look and cant see a way to add it myself), or theres something else i'm missing as the [mysqldump] option doesnt appear to work - even after restarting mariadb the same error occurs. It appears the official docker mariadb container uses /etc/mysql/my.cnf. 

fwiw i did C&P the mysqldump string that mythconverg_backup.pl uses and added the --column-statistics=0 parameter which works.