LOAD DATA LOCAL INFILE taking 1000 first lines

0

I'm using "LOAD DATA LOCAL INFILE" to import txt files, only it only imports the first 1000 lines, what do I do?

"LOAD DATA LOCAL INFILE 'temp_arq.txt'
INTO TABLE 'temp'
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\r\n' STARTING BY ''";
    
asked by anonymous 23.10.2018 / 13:48

1 answer

0

Most likely your problem is the size of the file, not the number of rows processed.
In this and # posts talks about changing the maximum file size to be read by changing php.ini :

upload_max_filesize = 10M
post_max_size = 10M
    
23.10.2018 / 14:46