Mysql no-auto-rehash client configuration conflicting with mysqldump

Question

Our database has many tables with many columns. It takes a long time to connect the mysql command-line client unless I pass -A . I would prefer not to use this every time, so I tried to add the my.cnf no-auto-rehash parameter.

This works fine until I use mysqldump:

mysqldump: unknown option '--no-auto-rehash'

Mysqldump seems to use the parameters in the my.cnf [client] section, even if there is a separate [mysqldump] section. Is there a way to use no-auto-rehash and still have functional mysqldump? Is there a [no-really-just-the-mysql-client] section?

Thanks.

The same question was asked in the mysql forums without an answer:

http://forums.mysql.com/read.php?35,583759,583760

Answer 1

Place the no-auto-rehash option in the [mysql] section instead of [client]

 [mysql] no-auto-rehash 

In this case, mysqldump is functional.

Answer 2

I do this all the time:

 [client] compress user=uuuuuuu password=ppppppppp [mysql] prompt=\h\_\d>\_ no-auto-rehash [mysqldump] quick max_allowed_packet=1G