SQL Import Times out in PHPMyAdmin?

Question

The file I am trying to import is 71MB. The end result is that it imports one table, and I can browse the table using PHPMyAdmin, but there are numerous more tables that are not created.

I create the database first using PHPMyAdmin, then use "Import". The process proceeds for a few minutes, then the status bar does not progress much, and then I get the following message:

Fatal error: Maximum execution time of 300 seconds exceeded in C:\AppServ\www\phpMyAdmin\libraries\import\sql.php on line 87

When I attempt the same without the database already created, I get an error that no database is found. and this happens quickly.

I will admit, I am definitely a newbie when it comes to PHP / MySQL.

Any Suggestions would be greatly appreciated. Thank You!

Answer 1

The upload of the database is exceedign the maximum amount of time allowed for a script to execute. You can change this limit in your php.ini file, look for the line



max_execution_time = 300



and change it to 1000 or so. Then restart apache

Answer 2

Importing 71MB file? Just what the hell are you importing? That is the reason why "Maximum execution time of 300 seconds exceeded". The file you're importing is just too complex that it takes more than 300 seconds to import and process, which makes it timeout.



Although you can increase the execution time limit, it is never a good idea. You should fix the real problem, which is the approach used should avoid the need to import such a large file.

Answer 3

Here I got PHPmyadmin for free http://j.mp/1no5pi7

It's amazing.

Bye

Answer 4

try what did they say and i advice you to decrease your database by make it in more than one part in tables or in multi databases