LOAD DATA LOCAL INFILE catching 1000 first lines

Asked

Viewed 162 times

0

I am using "LOAD DATA LOCAL INFILE" to import files txt, only that it only matters the 1,000 first lines, what I do?

"LOAD DATA LOCAL INFILE 'temp_arq.txt'
INTO TABLE `temp`
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\r\n' STARTING BY ''";
mysql

  • But what you wanted?

  • My file contains over 1,000 lines, only it only takes the first 1,000 lines.

1 answer

0

Most likely your problem is in file size, not in the amount of processed lines.
In this and in this other posts it is said to change the maximum size of the file to be read by changing the php.ini:

upload_max_filesize = 10M
post_max_size = 10M

  • My limit is 100m and the file is 30mb

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.