Fatal error: Maximum execution time of 300 seconds exceeded

Virgin_Steel · Worker Joined: Sep 30, 2004 Posts: 108 Location: Sf

Fatal error: Maximum execution time of 300 seconds exceeded in C:\www\xampp\phpmyadmin\libraries\read_dump.lib.php on line 186
How i can increase the execution time of 300 sec,`cause my db is too big
about 21,5 MB...i tried to seperate the db as it was written in one post...but it shows me 'No SQL query!'
but there is query with right syntax...

Code:

DROP TABLE IF EXISTS nuke_bbranks;
CREATE TABLE nuke_bbranks (
rank_id smallint(5) unsigned NOT NULL auto_increment,
rank_title varchar(50) NOT NULL default '',
rank_min mediumint(8) NOT NULL default '0',
rank_max mediumint(8) NOT NULL default '0',
rank_special tinyint(1) default '0',
rank_image varchar(255) default NULL,
PRIMARY KEY (rank_id)
) TYPE=MyISAM;

etc....
pls HELP!

Raven · Posted: Thu Jan 20, 2005 7:36 pm

The PHP script has a timeout that is in the php.ini. The MySQL server has a timeout. And the browser also has a timeout. Bottom line, either load the table in chunks (I recommend about 5,000 lines at a time) or, try this

Only registered users can see links on this board!
Get registered or login to the forums!

sixonetonoffun · Posted: Thu Jan 20, 2005 7:42 pm

If you have direct access just import it from the command prompt.
Here is a pretty good

Only registered users can see links on this board!
Get registered or login to the forums!

Raven · Posted: Sat Jun 04, 2005 10:24 am

You export the db using phpMyAdmin. Then you open the exported file in a good text editor that has line numbers. Then you copy and paste 5,000 lines at a time or you can try a higher number, into the SQL window in phpMyAdmin. Give

Only registered users can see links on this board!
Get registered or login to the forums!

a try first. It's a great program.

ysraghav · New Member Joined: Oct 04, 2008 Posts: 1

Raven wrote:

Give

Only registered users can see links on this board!
Get registered or login to the forums!

a try first. It's a great program.

This thing did it in two minutes what seemed like almost impossible to me. I tried everything else i guess but this was the only thing that worked. Try it out and you will love it.