, , , , , ,

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:)