puzzle abt maximum time of 360 secconds exeeded
Posted by: FuzMic (42.153.145.---)
Date: September 14, 2022 11:28AM

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?

Options: ReplyQuote
Re: puzzle abt maximum time of 360 secconds exeeded
Posted by: RiggsFolly (Moderator)
Date: September 14, 2022 01:57PM

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.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<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.

Options: ReplyQuote
Re: puzzle abt maximum time of 360 secconds exeeded
Posted by: FuzMic (168.235.203.---)
Date: September 14, 2022 02:08PM

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

Options: ReplyQuote
Re: puzzle abt maximum time of 360 secconds exeeded
Posted by: RiggsFolly (Moderator)
Date: September 14, 2022 03:20PM

I am fine thanks, hope youare too.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.2.8 32bit & 64bit) Aestan Tray Menu 3.2.4.7
<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-

Options: ReplyQuote
Re: puzzle abt maximum time of 360 secconds exeeded
Posted by: FuzMic (168.235.203.---)
Date: September 14, 2022 04:08PM

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.

Options: ReplyQuote
Re: puzzle abt maximum time of 360 secconds exeeded
Posted by: FuzMic (168.235.203.---)
Date: September 14, 2022 04:57PM

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

Options: ReplyQuote
Re: puzzle abt maximum time of 360 secconds exeeded
Posted by: Otomatic (Moderator)
Date: September 14, 2022 06:20PM

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

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.10 32 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.10 64 bit - Apache 2.4.54 - PHP 8.2.0…5.6.40 - MySQL 5.7.39/8.0.30 - MariaDB 10.5.17/10.9.2
PhPMyadmin 5.2.0 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: puzzle abt maximum time of 360 secconds exeeded
Posted by: FuzMic (168.235.203.---)
Date: September 15, 2022 03:35AM

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.

Options: ReplyQuote


Sorry, only registered users may post in this forum.