mysqldump fails if pager set in [client] config section

Viewed 323

I have this in my my.cnf:

[client]
pager = 'less -SRXF'

Which helps using mycli. However I've noticed that this causes mysqldump to fail mysqldump: unknown variable 'pager=less -SRXF

I've tried adding a [mysqldump] section without pager, or with pager = or with pager = '' or with skip-pager or with no-pager to overwrite the pager setting (as described in the docs) but none of that changes the error.

Interestingly:

$ my_print_defaults mysqldump
--quick
--quote-names
--max_allowed_packet=16M

(I've also tried solving this from the other end, using [mycli] or [mysql] instead of [client] but that does not seem to be read by the mycli program.)

I'm on MariaDB 10.0.32

0 Answers
Related