I use the Php+excel import MySQL class, I Excel total 351,901 pieces of data, but why each import into the database only 16,000 data, the remaining data will be re-imported to go in, how to set the number of imported bar.
Reply to discussion (solution)
Give you a stupid way:
Divide your Excel into n files, no more than 16000 lines per file. Import by file
You need to see what the cause of the interruption is.
Does your Excel class handle the upper limit?
Is your PHP taking up too much memory?
Database Import size settings? MySQL default is 2M?
It's estimated that your PHP execution timed out.
Add Set_time_limit (0) This on the first line of the PHP page
No problem with the data in section 16,001th
Personally, the number of imports is limited by the MySQL setup problem.
It is also recommended that you use SQLyog or other navicat to import. Very convenient.
You have to look at your SQL statement default execution time, is not timed out
I have changed the configuration of PHP, now well, hehe, thank you
Hello, you have PHP import Excel to MySQL case No, send me a bar, thank you