360 seconds maximum runtime exceeded in C: \ wamp \ apps \ phpmyadmin4.14

Question

I am trying to backup a Wordpress website from a host and transfer it to my local host and save it as a sample for rebuild. If you have workarounds or maybe other methods, I'm all ears

I also maintain my site and database, but when I try to "import" my sql database, I always get a false error. Fatal error: Maximum run time of 360 seconds exceeded in

C:\wamp\apps\phpmyadmin4.1.14\libraries\import.lib.php on line 345 

The database is big 203 MB, and I archived it aiesecbu_achieve.sql.zip 55.8 MB

I can say that I have already tried this: Fatal error: maximum execution exceeded and changing my php.ini

 post_max_size = 400M upload_max_filesize = 250M memory_limit = 128M 

I uploaded my database for you to check it if you want (maybe something is wrong with it) and a screenshot

https://www.dropbox.com/s/cx9wava7sptf4km/mysql.jpg?dl=0

Answer 1

You can try using the mysql console.

• Run cmd command
• Type c: or d: at the command prompt. This will be based on the settings of the WAMP server.
• Assuming you installed wamp on drive D :.
• 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

If you enter 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 effective.

Answer 2

As you installed phpMyAdmin4.1.14, I assume that you are using WAMPServer 2.5

In WAMPServer 2.5, the PHP resources used by phpMyAdmin are managed from the phpMyAdmin alias configuration file. It was changed specifically for these situations, so you do not need to change php.ini to add ridiculously large values ​​to parameters that affect your entire PHP environment.

So, to increase the corresponding paameters, you will do the following: -

Change \wamp\alias\phpmyadmin.conf , which by default should look like

 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 settings here, so they only affect what happens when you use phpMyAdmin.

These are the parameters you must change.

  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 the modification and see if it works, if not depending on the error, change the corresponding parameter.

Remember to restart Apache after every change to this file.

Oh and don't forget to undo the changes you made to php.ini

Answer 3

For the latest version of the 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 64bit)

try this: In the wamp\alias\phpmyadmin.conf file before the previous </Directory> statement, add four statements to get:

  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>