0

I have set the max_input_time 600000 and max_execution_time 600000, upload_max_filesize 1GB, memory_limit 512M But still my Script stops after 5 minutes of execution.

Basically what I want is, When I Run a PHP Script to Import or Export bigger Files. It exports just half file and Stops. Or If I try to upload 400 or 450 MB file It stops.

I tried import .sql file using PHP Script. It stopped after 5 Minutes and there were only 18 Tables with records were able to be imported in those 5 minutes, other 50 Tables were still pending.

I want to Run the Script at least for about 20 to 30 minutes, So My Script can complete the Process.

Please let me know what I should do, Should I Make some more changes in the php.ini file or something else. Whatever you will advise

Improve this question
4
  • 1
    I believe this is an x y problem If your script really needs 20 - 30 minutes to run, there's almost certainly a better way to do whatever it is doing. Perhaps you'd be better served if your php script were to queue all the exports it needs to perform in some way (via database records or rabbitmq etc) and then have another system that works that queue to process all the exports. Commented Nov 27, 2020 at 5:14
  • 1
    I think you should enable logs and check for critical errors. This way, you will know for sure what was the real reason of script break. Scripts could be breaked not only by memory/time allocation. Sometimes you could have invalid data for the script. Or in your situation, there maybe database connection break errors Commented Nov 27, 2020 at 5:52
  • @UrmatZhenaliev Yes. I have done so. The Data is Good. No issue with Data At all.if i import the same file manually, It works perfect. But if i do with the Script it stops Commented Nov 27, 2020 at 6:26
  • Even if data is Ok there should be information about error. It will show us the direction. Could you provide us with it? Commented Nov 27, 2020 at 6:30

1 Answer 1

Reset to default
0

Browser Does not support 20-30 minutes to waiting for a response from the server. You can run PHP scirpt file using the command line.

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

5 Comments

how i can use via command line. I am not aware of it. Please
Suppose we do not need the script to run for 20 to 30 minutes. But at least we need to run the script to process the full function. Suppose i have 48 Mib file sql . When i start importing it. It imports a part from it. not import full. after importing some part of it. it stops. Even if we use a smaller file having less records. it uploads full. So we cannot say that the script is not good. Just the timing is the issue only
and More over. This script will work behind the browser. how, I just uploaded a files. Started its process. I Closed the browser and starting watching in Database. Records are coming for about some minutes. Then records stops.
you can import .sql file using mysql command stackoverflow.com/questions/17666249/…
Yes. But there are many files. And The Admin will just select and Import the database. So, He dont know how to do with commands. So better is the PHP Importing. Just the issue is how to make a script keep running in background until the process is completed.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.