List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:August 28 2002 2:51pm
Subject:Re: load data into table from file or how to set the local-infile=1
View as plain text  
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 used command is not allowed with this MySQL version

MB> I searched the archives and found that a variable "local-infile=1" must
MB> be set for the client, but I can not find how to do that.

MB> Can somebody help me with this please?

MB> I'm using mysql version 3.23.49 on a Red Hat Linux 7.3.

Put into my.cnf file :
[mysql]
local-infile=1

or start mysql client with --local-infile=1 option.





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com


Thread
load data into table from file or how to set the local-infile=1variableMertens Bram28 Aug
  • Re: load data into table from file or how to set the local-infile=1Egor Egorov28 Aug
    • Re: load data into table from file or how to set the local-infile=1Mertens Bram28 Aug
      • Re: Re: load data into table from file or how to set the local-infile=1Egor Egorov29 Aug
  • Re: load data into table from file or how to set the local-infile=1Gerald Clark28 Aug
    • Re: load data into table from file or how to set the local-infile=1Mertens Bram28 Aug
      • Re: load data into table from file or how to set the local-infile=1Keith C. Ivey29 Aug
        • Re: load data into table from file or how to set the local-infile=1Mertens Bram29 Aug
    • Re: load data into table from file or how to set the local-infile=1Gerald Clark29 Aug