Hello, MySQL gurus,
Sometimes the 'local' option of 'load data infile' is disabled for
security reasons (that is what I got from web). What could be the security
problem? I have another question, is there any way to change a variable of
mysql server without shutting it down?
Thank you
Ginger,
can't speak to the log file issue but check out this
link for the dynamic server variables:
http://dev.mysql.com/doc/mysql/en/Dynamic_System_Variables.html
Best O'luck,
Tripp
--- Ginger Cheng [EMAIL PROTECTED] wrote:
Hello, MySQL gurus,
Sometimes the 'local' option of 'load
reason for not using load data infile local?
Hello, MySQL gurus,
Sometimes the 'local' option of 'load data infile' is disabled
for
security reasons (that is what I got from web). What could be the
security
problem? I have another question, is there any way to change a variable
of
mysql
Hi,
Im just wondering why MySQL ver 3.23.51 is not supporting LOAD DATA INFILE
syntax, I downgrade my server to the older one which is MySQL ver 3.23.44,
is there any bug about using it in the latest version?
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office)
:Re: LOAD DATA in LOCAL
Hi ,
check this: In MySQL 3.23.49 and MySQL 4.0.2 LOCAL will only work
if you
have not started mysqld with --local-infile=0 or if you have not
enabled
your client to support LOCAL. See section 4.2.4 Security issues with
LOAD
DATA
On Tuesday, 16. July 2002 08:55, [EMAIL PROTECTED] wrote:
Hi,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html
Regards Georg
-
Before
-
From: Jan Peuker [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 4:02 PM
To: [EMAIL PROTECTED]
Subject:Re: LOAD DATA in LOCAL
Hi,
* I am not a professional, but I think there is no error in your
config.
The statement runs