[Warning] wampmysqld64: Forcing close of thread 101 user: 'root'
Posted by: labrat49 (98.43.188.---)
Date: August 08, 2021 02:42AM

I have a CSV file with 42,000 records which phpMyAdmin cannot handle as expected. I have researched online the various timeout and limit settings that others state need to be increased to prevent timeout. MySQL error log says [Warning] wampmysqld64: Forcing close of thread 101 user: 'root' while the phpMyAdmin response looks like it will be successful, indicating the table name an stuff atop the window, but at the bottom of the window ir reads Error MySQL has gone away. I am guessing I need to add a maximum execution time to my.ini

The same CSV imports fine to a remote web server, but won't import okay on Windows 10 wampserver.

Re: [Warning] wampmysqld64: Forcing close of thread 101 user: 'root'
Posted by: Otomatic (Moderator)
Date: August 08, 2021 09:54AM

Hi,

> maximum execution time to my.ini
See the file wamp64\alias\phpmyadmin.conf

> The same CSV imports fine to a remote web server
See the differences of configuration between the remote server and MySQL of Wampserver.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.6 32 bit - Apache 2.4.51 - PHP 8.0.11…5.6.40 - MySQL 5.7.35 - MariaDB 10.5.12/10.6.4
Wampserver 3.2.6 64 bit - Apache 2.4.51 - PHP 8.0.11…5.6.40 - MySQL 5.7.35/8.0.26 - MariaDB 10.5.12/10.6.4
PhPMyadmin 5.1.1 - 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 »

Sorry, only registered users may post in this forum.