I have an API parsing script, which inserts into the db more than 40,000 rows.and maybe due large numbers of queries getting fired continuously, after some specific time the script throws "MySQL server has gone away" error.
I know the reason behind this error can be closed connection or any other privileges on the mysql server.
How should I deal with this error , so that i can execute the script completely.
network18
15
Practically a Master Poster
Recommended Answers
Jump to PostIf you really need to do this this way, then creating a msqli_multi_query could help. That way the server gets all queries at once, and does not need to handle each query separately.
All 4 Replies
pritaeas
2,179
¯\_(ツ)_/¯
Moderator
Featured Poster
Namibnat
10
Junior Poster in Training
network18
15
Practically a Master Poster
network18
15
Practically a Master Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.