LOAD DATA LOCAL INFILE revisited

[Pieter Van Waeyenberge]

Hello

i *had* it working ... i have everything in place as all documentation and
fora stated.. but yet i AGAIN get the error:

"The used command is not allowed with this MySQL version" in
/home/foo/public_html/goo/import.load.items.php on line..

LOAD DATA LOW_PRIORITY LOCAL INFILE
'/home/foo/public_html/goo/import/file.txt' REPLACE INTO TABLE discipline
FIELDS TERMINATED BY '{_^^)' LINES TERMINATED BY '\r\n' (col1,col2)
The context:

- PHP Version 4.3.8
- MySql: version - 4.0.17
- FreeBSD 4.9-RELEASE-p4 FreeBSD 4.9-RELEASE-p4 #1: Sun i386

- MySql has LOCAL_INFILE = On
- I connect to mysql using CLIENT_LOCAL_FLAGS: mysql_connect($host, $usr,
$pwd, false, 128);
- the open base dir is set to '/home/foo/'
- the directory 'import' where i get the file from has max permissions
- what i do in the app is: move the HTTP uploaded file to
'/goo/import/file.txt' ... (which is NOT the upload_tmp_dir) .. and then
later in another script i use the above sql statement
Am i missing something? help would be appreciated ..

thnx in advance ..
Pieter Van Waeyenberge

[GoL]

On Tue, 17 Aug 2004 16:00:30 +0200, "Pieter Van Waeyenberge"
<[e-mail]> wrote:

Hello

i *had* it working ... i have everything in place as all documentation and
fora stated.. but yet i AGAIN get the error:

"The used command is not allowed with this MySQL version" in
/home/foo/public_html/goo/import.load.items.php on line..

LOAD DATA LOW_PRIORITY LOCAL INFILE
'/home/foo/public_html/goo/import/file.txt' REPLACE INTO TABLE discipline
FIELDS TERMINATED BY '{_^^)' LINES TERMINATED BY '\r\n' (col1,col2)
The context:

- PHP Version 4.3.8
- MySql: version - 4.0.17
- FreeBSD 4.9-RELEASE-p4 FreeBSD 4.9-RELEASE-p4 #1: Sun i386

- MySql has LOCAL_INFILE = On
- I connect to mysql using CLIENT_LOCAL_FLAGS: mysql_connect($host, $usr,
$pwd, false, 128);
- the open base dir is set to '/home/foo/'
- the directory 'import' where i get the file from has max permissions
- what i do in the app is: move the HTTP uploaded file to
'/goo/import/file.txt' ... (which is NOT the upload_tmp_dir) .. and then
later in another script i use the above sql statement
Am i missing something? help would be appreciated ..

thnx in advance ..
Pieter Van Waeyenberge

It's local-infile=1, not local_infile = on
unless I'm mistaken...?
Additionally, both client and server needs local-infile enabled.

[Pieter Van Waeyenberge]

sorry for my late response

on or 1 .. both still fail me ...

and both client (PHP) and server (Mysql) have it enabled ... so it still
dont work

Worse yet .. i installed PhpMyAdmin and even there on the import file func i
get the same errors bor both methods:

with and without LOCAL !!!!!!

pieter van waeyenberge
"GoL" <^^@**.com> wrote in message
news:gf********************************@4ax.com...

On Tue, 17 Aug 2004 16:00:30 +0200, "Pieter Van Waeyenberge"
<[e-mail]> wrote:

Hello

i *had* it working ... i have everything in place as all documentation andfora stated.. but yet i AGAIN get the error:

"The used command is not allowed with this MySQL version" in
/home/foo/public_html/goo/import.load.items.php on line..

LOAD DATA LOW_PRIORITY LOCAL INFILE
'/home/foo/public_html/goo/import/file.txt' REPLACE INTO TABLE discipline
FIELDS TERMINATED BY '{_^^)' LINES TERMINATED BY '\r\n' (col1,col2)
The context:

- PHP Version 4.3.8
- MySql: version - 4.0.17
- FreeBSD 4.9-RELEASE-p4 FreeBSD 4.9-RELEASE-p4 #1: Sun i386

- MySql has LOCAL_INFILE = On
- I connect to mysql using CLIENT_LOCAL_FLAGS: mysql_connect($host, $usr,$pwd, false, 128);
- the open base dir is set to '/home/foo/'
- the directory 'import' where i get the file from has max permissions
- what i do in the app is: move the HTTP uploaded file to
'/goo/import/file.txt' ... (which is NOT the upload_tmp_dir) .. and then
later in another script i use the above sql statement
Am i missing something? help would be appreciated ..

thnx in advance ..
Pieter Van Waeyenberge

It's local-infile=1, not local_infile = on
unless I'm mistaken...?
Additionally, both client and server needs local-infile enabled.