How do I import a very large .SQL file using PHPMyAdmin?
Posted on 2009-05-14
I am trying to import a .SQL file using PHPMyAdmin. The file I am trying to import is 71MB.
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
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. It is timing out in the process and the full database is not created.
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 and I did try the same using the MySql command prompt suggestions posted in this forum, but nothing happens after executing the command.
Any Suggestions would be greatly appreciated. Thank You!