Hello
i have most recent php & mysql versions running on a linuxmachine
i want to use LOAD DATA LOCAL INFILE and pass it from php to mysql.
- the file i load is given with full path and the directory is readble
- On MySQL local-infile = ON
- From PHP i connect using client flag (128) to allow passing a file over
that connection: mysq_connect( $host, $usr, $pwd, false, 128)
Ive followed all advice from php & mysql sites and deja.com ...
But i still get the message: The command is not allowed with this MySql
Version or something ...
any ideas where i should look further?
what are *all* the requirements for a LOAD DATA LOCAL INFILE to work
seamingly?
Thnx
Pieter.
i have most recent php & mysql versions running on a linuxmachine
i want to use LOAD DATA LOCAL INFILE and pass it from php to mysql.
- the file i load is given with full path and the directory is readble
- On MySQL local-infile = ON
- From PHP i connect using client flag (128) to allow passing a file over
that connection: mysq_connect( $host, $usr, $pwd, false, 128)
Ive followed all advice from php & mysql sites and deja.com ...
But i still get the message: The command is not allowed with this MySql
Version or something ...
any ideas where i should look further?
what are *all* the requirements for a LOAD DATA LOCAL INFILE to work
seamingly?
Thnx
Pieter.