Best way to import large .sql files to PHPmyAdmin via WAMP

Hello everyone,

Say you get an error message in PHPmyAdmin as

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

Or you have reached maximum file upload limit.

On WAMP you can use following steps to ensure your .sql files gets through.

1. Click on the WAMP icon right next to time on your desktop.
2. Goto PHP > php.ini
3. php.ini file will open.
4. Now search for following variables in the file and change the values as given below
1. post_max_size = 750M
2. upload_max_filesize = 750M
3. max_execution_time = 300
4. max_input_time = 540
5. memory_limit = 1000M
5. Save and close the php.ini file.
6. Restart the WAMP server via the WAMP icon on the system tray, the option is called Restart all Services.
7. This should import a large .sql file.

What we are doing here is we are increasing the php variables to a larger level, like file size or execution time  etc, so now the PHPmyAdmin is capable enough to import a larger file easily.

In latest version of WAMP it is possible that some of the variables will not be found, but whatever you can find, you should replace it with higher values.

Hope it fixes your issue.

Thanx

Anshumaan Bakshi