NAS 326 MySql 'max_allowed_packet'

Michael_0007 Posts: 3

November 2021 in Personal Cloud Storage

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 !

0

Accepted Solution

• 

  Michael_0007 Posts: 3

  November 2021 Answer ✓

  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

• 

  Mijzelf Posts: 2,906  Guru Member

  

  November 2021

  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/
  

  
  
  

  0
• 

  Michael_0007 Posts: 3

  November 2021

  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 ?

  0
• 

  Mijzelf Posts: 2,906  Guru Member

  

  November 2021

  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.
  

  
  

  0
• 

  Michael_0007 Posts: 3

  November 2021 Answer ✓

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

  0