Fatal error: maximum excess exceeded

Question

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

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

and the import process is stopped. I have already increased max_execution_time in the php.ini file. Can someone help me solve this problem?

Answer 1

Do not modify the php.ini !

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

Before the </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 time or size as you wish .

Answer 2

You can also completely forget about phpMyAdmin and use mysql console

Using the wampmanager icon menu, do the following: -

 left click wampmanager -> MySQL -> MySQL Console 

If you changed the password for root userid, enter that when you called or if you did not change it, just press enter.

Make sure that there is a USE databasename file in the backup file if it is not entered manually, and then use the source command to start recovery from the backup file.

i.e.

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

Pay attention to the use of UNIX directory partitions even if you are in windows.

This tool has no time limits, since it is not a PHP script and will work until the end of your backup without any problems.

Answer 3

Although strongly discouraged, you can remove the maximum script time limit by setting max_execution_time to zero:

http://php.net/manual/en/info.configuration.php#ini.max-execution-time

If you have a more reliable way to get the file on the server (SFTP?), I suggest you try it first.