WampServer

Hi brothers

I have set php,ini to max_execution_time to 800 which shows in the php settings in the wampserver tray as 800. But when i import exported .sql of about 32M, there is a fatal error say "maximum execution time of 360 seconds exceed in mysqli.php on line 213. My puzzle why the error ignore the 800 i set.
what should i do instead?

I assume you are using phpMyAdmin to do the import, that has a seperate control for execution time.

Look in `C:\wamp64\alias\phpmyadmin.conf` it should look something like this

Alias /phpmyadmin "${INSTALL_DIR}/apps/phpmyadmin5.1.3/"

<Directory "${INSTALL_DIR}/apps/phpmyadmin5.1.3/">
  Options +Indexes +FollowSymLinks +MultiViews
  AllowOverride all
  Require local
# To import big file you can increase values
  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>

So you will have to amend the line

php_admin_value max_execution_time 800

To the new value, this is done so that you dont have to set the standard PHP execution time just in order to load a large Export back into a database.

You may also like to increase some of those other values, again the change will effect only execution of phpMyAdmin and not all your normal executions

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 2 time(s). Last edit at 09/14/2022 01:58PM by RiggsFolly.

Thank you .. much appreciate. ..will explore to fully understand.. by the way it is a while our path cross .. how is life treating you with EU turmoil

I am fine thanks, hope youare too.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

we in far east is away from food & energy stress with much bearable food cost increase & covid interruptions. Our life has to go the best route we plod on. Kind Regards.

Riggs
You mentioned that that I an using phyadmin, is there another way to import a SQL to the MySQL server

Hi,

- Adminer

- mysqldump.exe utility in the bin folder of MySQL
Very powerful and very complete. But in command line and with a very important documentation.
In the bin folder of mysql, type :
mysqldump --help | more
to get the help page by page.

Documentation

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

j'apprécie beaucoup mon frère otamatic
Am I right to assume by dumping I not subject to php settings



Edited 1 time(s). Last edit at 09/15/2022 04:25AM by FuzMic.