Environment: MySQL = 3.23.53-max-nt Windows 2000 Pro SP3 Apache 2.0.43 PHP 4.3.0 dev
Configure mysql startup as "Manual" in Windows 2000 Services.
E:\mysql\bin>mysqld-nt -local-infile=1From command prompt, run
The mysqld server would run but still does not allow LOAD DATA LOCAL INFILE.
Next run a script with the following query
$result = mysql_db_query($sql_db,"LOAD DATA LOCAL INFILE 'e:/htdocs/db_upload/export_file_name.txt' INTO TABLE imgprodtab2 FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n'") or die (mysql_error());
There following error is prompt on the browser:
The used command is not allowed with this MySQL version.
I have been using the script before without any problem, now upgrade to 3.25.53-max-nt. I know this is a security that disable the option, but starting mysqld with --local-infile=1 does not allow me to use the LOAD DATA LOCAL INFILE neither.
Please confirm whether this is a problem and provide me with some workaround if possible.
Thank you.
_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
