Hello im new to this forum and hope someone can help me 😃
My problem is this i wonder if there is a method in php to enable local_infile for mysql. As they say on www.mysql.com
If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, unless one calls mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0) in the client. See section 11.1.3.40 mysql_options().
I wonder if this "unless one calls mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0) in the client"
can be done by some php variables.
Coz im scripting a addon for phpNuke heres my support site for that addon http://protector.warcenter.se
And as some host provider don't configure MySQL with --enable-local-infile . then my script wont work for some users.
And i realy want the LOAD DATA LOCAL INFILE thing to work as i have a .cvs file whit 41043 records that i want in a db table. and I can't add it whit a .sql file whit phpMyAdmin as it will timeout.
I know i can split it but I realy hope it's a way to make this work to make it easy for my user to just upload the .cvs file whit my script and make the insert of this file whit the LOAD DATA LOCAL INFILE thing 😃
Thx in advance for all help and/or tips to make this work. 🙂
