1,105,423 Community Members

Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpmyadmin\li

keval_hack
Junior Poster in Training
66 posts since Jan 2010
Reputation Points: -3 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
Banned
 
0
 

I have data.sql file and there is 151262 insert statement in SQL file. but while i try to IMPORT it in MYSQL database this give me following error.


Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpmyadmin\libraries\import\sql.php on line 111


Pls give some solution for this Problem.


-keval

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

I think this is the PHP timeout of phpMyAdmin. So you can either change the php.ini and increase the timeout, or import the file directly into MySQL throught the command line.

keval_hack
Junior Poster in Training
66 posts since Jan 2010
Reputation Points: -3 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
Banned
 
0
 

But i don't know how to change php.ini pls can u tell me stem for that.

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

Location: C:\xampp\php\php.ini
Change max_execution_time

I still recommend the other method:
http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/

Member Avatar
tesuji
Master Poster
721 posts since Apr 2008
Reputation Points: 135 [?]
Q&As Helped to Solve: 98 [?]
Skill Endorsements: 0 [?]
 
0
 

Hello,

151262 rows are too much, they can hardly be inserted by means of insert statements and php because of too much time consuming. Instead, bulk insert should be done with MySQL LOAD DATA INFILE.

-- tesu

Member Avatar
pritaeas
mod_pritaeas
11,315 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,835 [?]
Skill Endorsements: 156 [?]
Moderator
Featured
Sponsor
 
0
 

@tesuji: Does LOAD DATA INFILE support sql dumps too ?

Member Avatar
tesuji
Master Poster
721 posts since Apr 2008
Reputation Points: 135 [?]
Q&As Helped to Solve: 98 [?]
Skill Endorsements: 0 [?]
 
0
 

I don't believe that files generated for processing with fast LOAD DATA INFILE to read them back into tables be compatible with mysqldump. However, mysqldump is able to generate complete insert-statements too. But I would never mix it.

There are many options one can set for speeding-up bulk-insert, for example delayed-insert (most important), disable-keys, no-locks.

-- tesu

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article