[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.

Options: ReplyQuote
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.

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

Options: ReplyQuote


Sorry, only registered users may post in this forum.