Otomatic Wrote:
-------------------------------------------------------
> Are the versions of MySQL between the old server
> (Database export) and the new one (Database
> import) the same?
They are not, the new server is on 5.7.24, and the old one should be running a 7 years old or so version I think, I can check the specific version later if needed, I installed it from an old EasyPHP pack.
> Have you compared the my.ini and PHP
> configurations between the old and new servers?
I checked the my.ini configuration before, I rechecked it again and I think the only possibly related changes are "skip-external-locking" "myisam_sort_buffer_size = 32M" which were in my old configuration file, I pasted them in the new one with no change. The other differences are mostly less stuff in the older file or lower numbers.
Here is the old one just in case: [
pastebin.com]
I would expect my problem to be related to a wrong configuration in this file but I can't see anything wrong after spending hours and hours looking on this issue. Perhaps I'm overlooking something.
I looked over my old php.ini just in case and I had a [MySQL] and a [MSSQL] section with some configuration parameters there and not in the new one, I copied them over to the new server just in case but nothing changed. I may be wrong but I believe php is not related the direct connections of my programs to the MySQL databases, but I checked the files either way to discard this possibility.
> And most importantly, have you seen the errors in
> the mysql and php log files?
All the timeouts don't seem to be generating errors that get recorded in MySQL logs unfortunately, I don't know if it's possible to change something to get that kind of error logged, I just enabled log_error_verbosity = 3 to see if that helped but nothing was added when my program crashed. Here's my log just in case, I think everything recorded is unrelated to my issue.
[
pastebin.com]