Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\misc\csv2sql.php on line 93

[ashishpanchal1985]

Hey,

I am trying to run it and it times-out after 30 sec with the above error. Can you tell me how to increase this timeout window for LOAD DATA LOCAL INLINE command?

Regards, Ashish

[hashmap0x01]

Hey,

I am trying to run it and it times-out after 30 sec with the above error. Can you tell me how to increase this timeout window for LOAD DATA LOCAL INLINE command?

Regards, Ashish

A detailed console log will be helpful to rectify the error

[godigi]

It is not SQL timing out, but PHP execution time limit. Add the following to the beginning of the script:

<?php
set_time_limit(0);
?>

If that doesn't work, you will need to increase max script timeout in php.ini.

[Sadhik-Hussain]

replace default value of max_execution_time=30 to max_execution_time=120. it will work

in php.ini file of your server. find the file here ‘xampp/php/’.