Current Page: 1 of 1
Results 1 - 6 of 6
3 years ago
PaulR
My extensive thanks did not go trough :/ I wanted to notify that the later procedure you kindly provided works fine. Thanks
Forum: WampServer English
3 years ago
PaulR
Hello Thanks a million ! This last proposition worked for me !!! For ref this worked for me : I have TAB delimited data. Inserting '\t' as shown in clip returned an error. Quick search surfaced . It says If you specify no FIELDS or LINES clause, the defaults are the same as if you had written this: FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY
Forum: WampServer English
3 years ago
PaulR
The error message points to this section of php.ini file. I uncommented the 2 last lines. ; Maximum number of persistent links. -1 means no limit. ; mysqli.max_persistent = -1 ; Allow accessing, from PHP's perspective, local files with LOAD DATA statements mysqli.allow_local_infile = ON
Forum: WampServer English
3 years ago
PaulR
this is my.ini the one in the mysql8.0.21 subdir -------------------- ; MySQL config file. ; ; MySQL programs look for option files in a set of ; locations which depend on the deployment platform. ; You can copy this option file to one of those ; locations. For information about these locations, see: ; ; ; In this file, you can use all long options that a program supports. ; If you
Forum: WampServer English
3 years ago
PaulR
Thank you for your reply. I saw and read that document. It was the link i posted initially. But did not find answer to my question in it :/ Actually maybe it does, but the whole thing is cryptic : To me it sounds like replying how a chronowatch is made and works when simply asking for time !:O The document does not explecitly say it's impossible, but does not state simply how to achieve thi
Forum: WampServer English
3 years ago
PaulR
Hello, I get this error #2000 - LOAD DATA LOCAL INFILE is forbidden, check mysqli.allow_local_infile while using LOAD DATA LOCAL INFILE '/wamp64/somefile.txt' INTO TABLE fscore.num FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n'; in phpmyadmin sql command window I searched hours over days troughout the internet and modified every php.ini and my.ini to co
Forum: WampServer English
Current Page: 1 of 1