security reason for not using load data infile local?

2004-04-12 Thread Ginger Cheng
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

Re: security reason for not using load data infile local?

2004-04-12 Thread Emmett Bishop
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

RE: security reason for not using load data infile local?

2004-04-12 Thread Victor Pendleton
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

LOAD DATA in LOCAL

2002-07-16 Thread RBRoa
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

2002-07-16 Thread RBRoa
: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

Re: LOAD DATA in LOCAL

2002-07-16 Thread Georg Richter
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

RE: LOAD DATA in LOCAL

2002-07-16 Thread RBRoa
- 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