List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:April 16 2007 10:45am
Subject:Re: Problem with mysqldump and local-infile
View as plain text  
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=1
>
>
> --
> 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.

Thread
Problem with mysqldump and local-infileMark van Herpen16 Apr
  • Re: Problem with mysqldump and local-infileMogens Melander16 Apr
  • Re: Problem with mysqldump and local-infileDing Deng16 Apr