Maximum execution time of 360 seconds exceeded in C:\wamp\apps\phpmyadmin4.1.14
You can try to use mysql console.
- Run
cmd
command - Type
c:
ord:
on command prompt. This will be based on your WAMP server installations. - Assuming you have installed wamp on D: drive.
D:\>cd wamp
D:\wamp>cd bin
D:\wamp\bin>cd mysql
D:\wamp\bin\mysql>cd mysql15.1.36
D:\wamp\bin\mysql\mysql15.1.36>cd bin
D:\wamp\bin\mysql\mysql15.1.36\bin>mysql.exe -u root
use database
source source.sql
Bassicaly you login into mysql, use database
determines which database you want to use, source /source/to/source.sql
determines which sql you want to run. Pretty easy and efficient.
As you have phpMyAdmin4.1.14 installed I assume you are using WAMPServer 2.5
In WAMPServer 2.5 the PHP resources used by phpMyAdmin are controlled from the phpMyAdmin alias config file. It was changed for exactly these situations, so you dont have to change the php.ini
to add a ridiculously large values to parameters that effect your whole PHP environment.
So to increase the relevant paameters you would do this :-
Edit \wamp\alias\phpmyadmin.conf
which should look like this by default
Alias /phpmyadmin "c:/wamp/apps/phpmyadmin4.1.14/"# to give access to phpmyadmin from outside # replace the lines## Require local## by## Require all granted#<Directory "c:/wamp/apps/phpmyadmin4.1.14/"> Options Indexes FollowSymLinks MultiViews AllowOverride all <IfDefine APACHE24> Require local </IfDefine> <IfDefine !APACHE24> Order Deny,Allow Deny from all Allow from localhost ::1 127.0.0.1 </IfDefine> php_admin_value upload_max_filesize 128M php_admin_value post_max_size 128M php_admin_value max_execution_time 360 php_admin_value max_input_time 360</Directory>
Now change the parameters here, so they only effect what happens when you are running phpMyAdmin.
These are the parameters you should amend
php_admin_value upload_max_filesize 500M <-- and probably this php_admin_value post_max_size 128M php_admin_value max_execution_time 620 <-- this for a start php_admin_value max_input_time 360
But basically try a modification and see if it works, if not depending on the error amend the relevant parameter.
Dont forget to restart Apache after each change you make to this file
Oh and dont forget to undo the changes you made to php.ini
For the latest version of wamp server:
- Wampserver 2.5.17 32bits
- Apache 2.4.17/2.2.31
- PHP 5.6.14/7.0.0rc5/5.5.30/5.4.45/5.3.29
- MySQL 5.6.27/5.7.9/5.5.46/5.1.73/5.0.83
- PhPMyAdmin 4.5.0
- MysqlDumper 1.24.4 (W7 Pro 64bits)
try this out:In wamp\alias\phpmyadmin.conf
file, just before the last statement </Directory>
add four statements to obtain:
php_admin_value upload_max_filesize 512M php_admin_value post_max_size 512M php_admin_value max_execution_time 900 php_admin_value max_input_time 900</Directory>