Uplad txt field of size greater than 12 mb
I have to upload .txt file in mysql table. This data is to be displayed by using mysql qureries. I have use upload .txt file by code shown below
$destinationdir = "/var/www//html/telephone/uploadfiles/";
$destinationfile = $destinationdir . $_FILES['myfile']['name'];
$bloadquery="load data local infile '$destinationfile' into table billtable fields terminated by '|' enclosed by '' lines terminated by '\\r\\n'";
This code working well for uploadding 150000 (approx) lines means file of size in 50 kb but it fails for for uploading file having size 12 mb or more than 12 mb.
So please suggest me what should i change so that full file having more than 12 mb can be upladed