NAS 326 MySql 'max_allowed_packet'
Options
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
- 397 Beta Program
- 2.1K Nebula
- 116 Nebula Ideas
- 78 Nebula Status and Incidents
- 5.1K Security
- 52 USG FLEX H Series
- 247 Security Ideas
- 1.3K Switch
- 70 Switch Ideas
- 907 WirelessLAN
- 34 WLAN Ideas
- 5.9K Consumer Product
- 211 Service & License
- 332 News and Release
- 71 Security Advisories
- 21 Education Center
- 5 [Campaign] Zyxel Network Detective
- 1.9K FAQ
- 880 Nebula FAQ
- 415 Security FAQ
- 221 Switch FAQ
- 195 WirelessLAN FAQ
- 46 Consumer Product FAQ
- 137 Service & License FAQ
- 34 Documents
- 34 Nebula Monthly Express
- 72 About Community
- 63 Security Highlight