Etiketler
max_allowed_packet, my.cnf, my.ini, mySQL, mysql 5.7, mySQL 500, mySQL server
If you could not find my.cnf or my.ini file on the latest versions of MySQL, I can help you to find out. As usual, for a huge data transfer I met an error for maximum allowed package and I tried to change the value of “max_allowed_packet”, however I could not find the configuration file anywhere inside the MySQL folder. After a while I recognized that new versions of MySQL keeps my.ini file inside a folder addressed below:
C:\ProgramData\MySQL\MySQL Server 5.7\my.ini
After increasing “max_allowed_packet” value under the [mysqld] section from 16M to 100M problem is resolved. If you met the similar problem please try:)