Topic: Getting Fatal error: Maximum execution time of 300 seconds exceeded .......

[veeraa2003]

Hi every body ...

Its me veeraa , I'm beginner in using LAMPP,

I got the error while try to import a big SQL (184 MB) in to SQLMyAdmin ,
Fatal error: Maximum execution time of 300 seconds exceeded

I try to change the value of memory_limit = 184M and max_execution_time = 0  in Php.ini file and restart the lampp. But still got the problem,

Now using the option of partial import, its consuming more time .

can any one help with other option..

I think i explained my problem upto my level . If any mistake on this please forgive me .

[thorpe]

Import this through the terminal mysql program. Why are you using php to do this?

[kevinkorb]

At the beginning of your script you can add.


ini_set('MAX_EXECUTION_TIME', -1);

[veeraa2003]

Hi

Thanks for your kind replies . I can't overcome the above problem.

where I should put this code ;

ini_set('MAX_EXECUTION_TIME', -1);

 My database is in a textfile with the extension .sql

[kevinkorb]

At the very top of your php file.

[veeraa2003]

At the very top of your php file.

That nice ...

Now no problem on my import. Thanks for your reply .......................

[susan123]

I am trying to upload a big database of size 21 MB using phpmyadmin (import) but after sometime it is giving this errornbrc test

Fatal error: Maximum execution time of 300 seconds exceededncbtmb test


Now it self explaintory, so what shoud I do ? I am using Xampp on my local system and I think I can only use phpmyadmin to load the DB