PHP script execution stops during big SQL execution

Question

Am executing PHP script to migrate tables from one server DB to another server DB.

The script unnecessarily stops execution during large no. of INSERT command is executed. eg:transfer 15000rows to a table using mysqli_query("INSERT INTo....VALUES(....)") then execution stops.

already initialized: set_time_limit(0); ini_set('mysql.connect_timeout', '0'); ini_set('max_execution_time', '0');

Is there any other solutions available?

Is it possible to split your query into multiple queries, where the queries would insert smaller amount of rows? — mrinx
– mrinx, Commented Feb 20, 2015 at 10:06
@PetrNovak , it's a good comment, but unfortunately i already tried this. Actually the exact problem arrives when the large no. of rows table operates. One more thing is that the particular table is successfully completed insertion, the error occurs with the next table's. — Shijo Rose
– Shijo Rose, Commented Feb 20, 2015 at 11:05
Can you then split one script into multiple scripts (let's say one script per table), so the script won't timeout? — mrinx
– mrinx, Commented Feb 20, 2015 at 11:14

Rafael · Accepted Answer · 2017-08-01 21:47:15Z

1

I know it's been a while since you asked the question, but I am having a similar problem and I just solved it by using:

http://php.net/manual/en/function.set-time-limit.php

As long as you are not running your script in safe mode, though. Otherwise, you will have to change the time limit in php.ini.

Hope this helps to someone else with the same problem.

answered Aug 1, 2017 at 21:47

Rafael

113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arun · Accepted Answer · 2015-02-19 10:51:25Z

0

Please Declare

ini_set('max_execution_time', '-1');

answered Feb 19, 2015 at 10:51

Arun

7605 silver badges12 bronze badges

2 Comments

Shijo Rose Over a year ago

is it really a solution?

Arun Over a year ago

Yes.. you will try this

Collectives™ on Stack Overflow

PHP script execution stops during big SQL execution

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related