From: Mogens Melander
Date: April 16 2007 10:45am
Subject: Re: Problem with mysqldump and local-infile
List-Archive: http://lists.mysql.com/mysql/206180
Message-Id: <2729.90.184.17.152.1176720342.squirrel@mail.fumlersoft.dk>
MIME-Version: 1.0
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit

It looks to me that local-infile is a command-line parameter
to mysql client

mysql --local-infile -u user dbname

I've not been able to find this option elsewhere.

-- 
Later

Mogens Melander
+45 40 85 71 38
+66 870 133 224


On Mon, April 16, 2007 12:14, Mark van Herpen wrote:
> Hi,
>
> 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:
>
> [client]
> 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?
>
> Grtz,
>
> Mark van Herpen
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=mogens@stripped
>
>
> --
> This message has been scanned for viruses and
> dangerous content by OpenProtect(http://www.openprotect.com), and is
> believed to be clean.
>



-- 
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.