Fatal error: Maximum execution time of 300 seconds exceeded

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!

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

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 http://www.ozerov.de/bigdump.php

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!

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 http://www.ozerov.de/bigdump.php a try first. It's a great program.

New Member Joined: Oct 04, 2008 Posts: 1

Raven wrote:

Give http://www.ozerov.de/bigdump.php 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.

New Member Joined: May 08, 2009 Posts: 1

hi:
i have same error but the thing is i have 112 tables but after it gave me this error just 98 of my tables are in !!!!can you help me Sad

Posted: Fri May 08, 2009 7:27 am

Same error = same solution. Get bigdump and use it.

registered · Posted: Fri May 08, 2009 12:37 pm

Quote:

C:\www\xampp\phpmyadmin\libraries\read_dump.lib.php on line 186

This error message says you are using experimental AMP (Apache + MySQL + php).
Whatever the size of your DB will be, you may go to 'command prompt (ie, command window)'.
Then, change your directory to

c:\www/xampp\mysql\bin\

Then, use direct dump as follows:

mysql -u YOUR-DB-USERNAME -p YOUR-DB-NAME < YOUR-DB-SQL file.

As you know, this is the fastest way and no time limit, no size limit, and no troubles.

In this context, some of web-hosting companies support SSH Shell access, even though they charge little bit more.

Worker Joined: Aug 26, 2007 Posts: 236

I recommend MySQLDumper for backup and restore of huge databases.
http://www.mysqldumper.de/en/