Best way to import large .sql files to PHPmyAdmin via WAMP
Posted by: tjalign (---.alignex.com)
Date: September 05, 2012 04:22PM

Hi,

I'm looking for the best way to import large .sql files to PHPmyAdmin via WAMP. I keep reaching limits.

Re: Best way to import large .sql files to PHPmyAdmin via WAMP
Posted by: stevenmartin99 (Moderator)
Date: September 05, 2012 04:42PM

Increase the limits smiling smiley

Left click wamp > php> php.ini

Find:
post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Change to:
post_max_size = 750M
upload_max_filesize = 750M
max_execution_time = 300
max_input_time = 540
memory_limit = 1000M

Save and restart wamp

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Re: Best way to import large .sql files to PHPmyAdmin via WAMP
Posted by: tjalign (---.alignex.com)
Date: September 05, 2012 05:49PM

I keep getting this error:

"Script timeout passed, if you want to finish import, please resubmit same file and import will resume."

When I try to import again, it just keeps importing without acknowledging when it is actually finishing the job.

Re: Best way to import large .sql files to PHPmyAdmin via WAMP
Posted by: stevenmartin99 (Moderator)
Date: September 05, 2012 05:53PM

in the phpmyadmin config.inc.php you can increase the time out from 300sec to infinity

add this line

$cfg['ExecTimeLimit'] = 0;

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Sorry, only registered users may post in this forum.