mysqldump fails if pager set in [client] config section

Asked Oct 02 '17 at 11:37

Active Oct 02 '17 at 11:37

Viewed 357 times

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

asked Oct 02 '17 at 11:37

artfulrobot

20,637
11
55
81

1

You can't add options to `[client]` that aren't compatible with *all* client utilities. – Michael - sqlbot Oct 02 '17 at 19:31
Right. I'll work on mycli to implement a custom section then. Thanks. – artfulrobot Oct 02 '17 at 20:51
That sounds like the best plan. A custom section should automatically not interfere with anything else. – Michael - sqlbot Oct 02 '17 at 21:22
If that fails, file a bug report with bugs.mysql.com. (and/or the MariaDB equivalent in Jira.) – Rick James Oct 07 '17 at 01:47

mysqldump fails if pager set in [client] config section

0 Answers0