Kevin212
asked on
How do I import a very large .SQL file using PHPMyAdmin?
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!
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\
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!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok, thank you. one thing I am not clear onL in your syntax, I don't see where I indicate the backed-up .sql file that needs to be imported. if the file is named "test.sql", were does that factor into thet syntax you mentioned?, let's assume the database is named Testdb in PHPMyAdmin
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I used that exact syntax, with the propper User name and PW, with the tes.sql file in the "C:\AppServ\MySQL\bin" directory. Nothing happens, just a flashing cursor on the next line.
do I need to put that .sql file in a different directory? 0r to I need to do specify a hard path such as:
mysql.exe -u user -p password Testdb < C:\Temp\test.sql
??
do I need to put that .sql file in a different directory? 0r to I need to do specify a hard path such as:
mysql.exe -u user -p password Testdb < C:\Temp\test.sql
??
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the test.sql file is in the current folder, you don't need to specify the path.
ASKER
Thank you very very much for your help, Unfortunately...
..not sure what I am missing here. I'm doing exactly as stated, but again, just a flashing cursor. When I look in the .."MySQL\Data\Testdb" folder, there is only the file "db.opt"
..not sure what I am missing here. I'm doing exactly as stated, but again, just a flashing cursor. When I look in the .."MySQL\Data\Testdb" folder, there is only the file "db.opt"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did that, no errors or anything.
I think I will satrt from scratch. Is there a particular version of WAMP that you suggest I install, don't wanna spin my wheels if there is a version issue going on here..
I think I will satrt from scratch. Is there a particular version of WAMP that you suggest I install, don't wanna spin my wheels if there is a version issue going on here..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I recommend that you just edit your .sql file. Split it into smaller files. If it is a PHPMyAdmin dump it is very verbose. So cut it at the comment sections and just upload it in multiple files.
mysql dbname < sql.php