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
Categories
- 8.5K All Categories
- 1.6K Nebula
- 72 Nebula Ideas
- 57 Nebula Status and Incidents
- 4.5K Security
- 227 Security Ideas
- 986 Switch
- 46 Switch Ideas
- 883 WirelessLAN
- 24 WLAN Ideas
- 5.2K Consumer Product
- 158 Service & License
- 280 News and Release
- 61 Security Advisories
- 13 Education Center
- 581 FAQ
- 263 Nebula FAQ
- 160 Security FAQ
- 76 Switch FAQ
- 75 WirelessLAN FAQ
- 7 Consumer Product FAQ
- 34 Documents
- 34 Nebula Monthly Express
- 62 About Community
- 46 Security Highlight
Consumer Product Help Center
