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 .......................

[wattaman]

There is a php script I've used one time, one file only, that can import big databases no matter if the time limitations of the php; the script import tables in parts and it refreshes the page after importing one part, then loads the next part (tables, fields etc). Unfortunately, I've forgot its name, by try searching it on the net using its description as search term... maybe other members can post its name here.