We use the Windows SQLyog software and try to import a large database but the following error happens.
Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes
I know there are other topics to increase the max upload size but is for the php only and reflects the phpmyadmin import procedure.
We want to change the config from mariadb server to allow bigger db uploads but the my.cnf file on /etc/my.cnf is empty.
How to resolve this?