NAS 326 MySql 'max_allowed_packet'

Michael_0007

I am using on board MySql  as my db server on NAS 326.
When i try to load big files i got error 
1153, "Got a packet bigger than 'max_allowed_packet' bytes".
How and where i can set proper value for that entry ?
Thanks for answer !

Michael_0007

i tryed find / | grep ".cnf"
But except those files nothing similar my.cnf
Looks like mission imposible.Any way , thanks for help.

Mijzelf

https://www.howtoforge.com/mysql-got-a-package-bigger-than-max_allowed_packet-bytes

On your 326 the config file will be somewhere in /i-data/sysvol/.PKG/PHPMySql/etc/

Michael_0007

Thanks a lot Mijzelf !
Finally i find the path :  

/i-data/f1f3cd51/.PKG/PHP-MySQL-phpMyAdmin/mysql/share/mysql

There are bunch of cnf files :

my-huge.cnf                   

my-innodb-heavy-4G.cnf 

my-large.cnf                    

my-medium.cnf           

my-small.cnf 
Which one to change ? May be all of them ?

Mijzelf

None of them, I think. Files in the /share/ directory are in most cases 'shared' files, (hey!), and in this case I think it are just sample config files to copy and use in different circumstances.

Try

find /i-data/f1f3cd51/.PKG/PHP-MySQL-phpMyAdmin/ | grep ".cnf"

to find the right one.

Michael_0007

i tryed find / | grep ".cnf"
But except those files nothing similar my.cnf
Looks like mission imposible.Any way , thanks for help.