Christy,
Tuesday, May 07, 2002, 3:07:25 PM, you wrote:
CR>> I've been trying to import text files into MySQL, but I can't get it
CR> to
CR>> work. I'm new to MySQL and am still getting familiar with it, so
CR>> perhaps I'm missing something. I'm using the LOAD DATA LOCAL
CR> command
CR>> but I keep getting error 1148 "The used command is not allowed with
CR> this
CR>> MySQL version." Now from reading the information in the docs
CR> section
CR>> (http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html) it appears that
CR> LOAD
CR>> DATA LOCAL is sometimes disabled for security reasons, and that
CR> there
CR>> are two ways around this.
CR> Christy, give me some more info:
CR> 1. What OS are your using?
CR> 2. What MySQL server are you using (version, binary or source
CR> distribution etc.)?
CR> 3. What is your client software?
CR> Hi Egor - we're running Windows XP on that machine. We're running MySQL
CR> version 3.23.49, binary distribution.
Add in your my.cnf file rows:
[mysqld]
local-infile=1
[client]
local-infile=1
CR> I'm not sure what you mean by
CR> "client software." Doesn't MySQL include server and client?
Sure, MySQL has server and client packages, but in Windows binary
they combine into one package.
CR> Maybe I'm
CR> missing something here. :)
:) Seems, you have worked only with Windows ...
CR> Thanks,
CR> Christy
CR> :)
--
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
