It shoul d be running as user mysql .
Mertens Bram wrote:
>On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote:
>
>>As it says in the documentation, "If the LOCAL keyword is specified,
>>the file is read from the client host. If LOCAL is not specified, the
>>file must be located on the server."
Mertens,
Wednesday, August 28, 2002, 6:52:12 PM, you wrote:
MB> On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
>> Put into my.cnf file :
>> [mysql]
>> local-infile=1
>>
>> or start mysql client with --local-infile=1 option.
MB> I tried the first option and it works when use the following comma
On Wed, 2002-08-28 at 22:19, Keith C. Ivey wrote:
> As it says in the documentation, "If the LOCAL keyword is specified,
> the file is read from the client host. If LOCAL is not specified, the
> file must be located on the server." That means that with LOCAL the
> MySQL *client* must be able t
On 28 Aug 2002, at 20:07, Mertens Bram wrote:
> Sorry, I don't understand: why would mysql have access to a file when I
> run LOAD DATA LOCAL... and not when I run it without the LOCAL?
As it says in the documentation, "If the LOCAL keyword is specified,
the file is read from the client host. I
On Wed, 2002-08-28 at 20:02, Gerald Clark wrote:
> I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Sorry, I don't understand: why would mysql have access to a file when I
run LOAD DATA LOCAL... and not when I run it without the LOCAL?
If I run it with LOCAL the data is added to the tab
I doubt mysql as access to /home/M8ram/testmysql/pet.txt.
Mertens Bram wrote:
>On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
>
>>Put into my.cnf file :
>>[mysql]
>>local-infile=1
>>
>>or start mysql client with --local-infile=1 option.
>>
>
>I tried the first option and it works when use the f
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote:
> Put into my.cnf file :
> [mysql]
> local-infile=1
>
> or start mysql client with --local-infile=1 option.
I tried the first option and it works when use the following command to
load the data-file:
mysql> LOAD DATA LOCAL INFILE '/home/M8ram/testm
Mertens,
Wednesday, August 28, 2002, 10:54:12 AM, you wrote:
MB> I was following the example in the manual (the menagerie database) but I
MB> can not load a file into the table, i get the following error:
MB> mysql> LOAD DATA LOCAL INFILE "~/testmysql/pet.txt" INTO TABLE pet;
MB> ERROR 1148: The
