PHP Myadmin MySql Error

[balaji2u]

I was just trying to upload some data to the tables in my database for my new site.
The backup data is in text fie and i used phpmyadmin to upload the data to the database the size of the backup text file is about 1.52MB when i started uploading mozilla remains showing the sending request msg in status bar and after some time the status changed to waiting for phpmyadmin something like that and then i hope that the data is uploaded to the database but unfortunately it returned me an error message stating that

Fatal error: Maximum execution time of 300 seconds exceeded in 

/usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/string_mb.lib.php on line 47

Please tell the possible reason for this and what shall i have to do to clear it..i also used to run the query directly but the browser goes blank after that..please help me.

 

[compwhizii]

Fatal error: Maximum execution time of 300 seconds exceeded in

Your answer is in the question. It's taking more than 5 minutes to process, so the server kills it (which is a good thing). So unless you can split the backup or query into smaller chunks there's not much to do.

 

[balaji2u]

yeah . . .
how can i split the query into many sub parts selecting small chunks and doing this is a tedious process coz im having 25, 000 records in it.is there any software or some thing to do splitting.

 

[compwhizii]

yeah . . .
how can i split the query into many sub parts selecting small chunks and doing this is a tedious process coz im having 25, 000 records in it.is there any software or some thing to do splitting.

Ouch. If you would pm me the SQL files I could try and split it.