Fatal error: Maximum execution exceeded

Question

I am trying to import a large database into my WAMP 2.5 server phpmyadmin. After importing some tables an error occurs:

Fatal error: Maximum execution time of 360 seconds exceeded in C:\wamp\apps\phpmyadmin4.1.14\libraries\dbi\DBIMysqli.class.php on line 285

and the importing process is stopped. I have already increased max_execution_time in my php.ini file. Can anyone help me resolve this problem?

Answer 1

Don't modify the php.ini file !

Modify the alias of the phpMyAdmin file : J:\wamp\alias\phpmyadmin.conf

Before the line </Directory>, you can describe what you want :

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>

You can change the values of time or size as you want.

Answer 2

You can also forget about phpMyAdmin completely and use the mysql console

Using the wampmanager icon menus do the following :-

left click wampmanager -> MySQL -> MySQL Console

If you have changed the password for the root userid enter that when challenged or if you have not changed it just hit enter.

Make sure there is a USE databasename in the backup file, if not enter it manually now and then use the source command to run the restore from your backup file.

i.e.

USE YourDatabase;
SOURCE C:/path/to/backup/file.sql;

Note the use of UNIX directory seperators even though you are on windows.

This tool has no time limitations as its not a PHP script, and will run to the end of your backup with no issues.