fix MySQL hangup problem
fix MySQL hangup problem in WHM/cPanel Server
How-to: Troubleshoot MySQL most common issues on a cPanel server
Dis-Allowing cPanel & WHM to change MySQL open_files_limit configuration
Login to WHM and Search for Tweak Settings open it.
Inside Tweak Settings goto SQL Tab and look toggle for Allow cPanel & WHM to determine the best value for your MySQL open_files_limit configuration?
We will turn it off and press the save button below.
- Repairing MySQL databases using "mysqlcheck"
"mysqlcheck" is a great utility used to repair MySQL databases while MySQL is running. So, there is no downtime and it is a safe method to repair databases.
To repair all databases using mysqlcheck:
::mysqlcheck -A --auto-repair
remove-MySQL-Governor
100 %
mysqldump: Error 2013: Lost connection to server during query when dumping
:
https://www.basezap.com/fix-mysql-hangup-problem-whm/
https://support.cpanel.net/hc/en-us/...-cPanel-server
https://support.cpanel.net/hc/en-us/...MySQL-Governor