Tuesday, January 5, 2016

MySQL pager setting in ~/.my.cnf

I like setting the pager to less for the mysql client.  When I do it in my ~/.my.cnf file, thus...

[client]
pager=less

I get an error when running mysql dump...

mysqldump: unknown variable 'pager=less'

Turns out mysqldump also reads the [client] section of the file, as well as [mysqldump].  Using the following works...

[mysql]
pager=less