NAS 326 MySql 'max_allowed_packet'

Michael_0007
Posts: 3
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 !
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 !
0
Accepted Solution
-
i tryed find / | grep ".cnf"
But except those files nothing similar my.cnf
Looks like mission imposible.Any way , thanks for help.0
All Replies
-
On your 326 the config file will be somewhere in /i-data/sysvol/.PKG/PHPMySql/etc/
0 -
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.cnfmy-innodb-heavy-4G.cnfmy-large.cnfmy-medium.cnfmy-small.cnf
Which one to change ? May be all of them ?0 -
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.Tryfind /i-data/f1f3cd51/.PKG/PHP-MySQL-phpMyAdmin/ | grep ".cnf"to find the right one.
0 -
i tryed find / | grep ".cnf"
But except those files nothing similar my.cnf
Looks like mission imposible.Any way , thanks for help.0
Categories
- All Categories
- 417 Beta Program
- 2.5K Nebula
- 160 Nebula Ideas
- 108 Nebula Status and Incidents
- 5.9K Security
- 331 USG FLEX H Series
- 286 Security Ideas
- 1.5K Switch
- 78 Switch Ideas
- 1.2K Wireless
- 42 Wireless Ideas
- 6.6K Consumer Product
- 259 Service & License
- 402 News and Release
- 86 Security Advisories
- 31 Education Center
- 10 [Campaign] Zyxel Network Detective
- 3.8K FAQ
- 34 Documents
- 34 Nebula Monthly Express
- 85 About Community
- 80 Security Highlight