I want to backup my databases with mysqldump, but mysqldump won't run
because I use the 'local-infile=1' option in the my.cnf file:
port = 3306
socket = /tmp/mysql.sock
local-infile = 1
This is because I want php and other clients to use local-infile. This
works, by when I start mysqldump I got this error:
~ # mysqldump
mysqldump: unknown variable 'local-infile=1'
So, what is wrong? As far as I know local-infile is a valid option to
put in the my.cnf.
Is there a way to unset the local-infile option and start then start
mysqldump or something? Or any other solution?
Mark van Herpen