NAS 326 MySql 'max_allowed_packet'

Michael_0007
Michael_0007 Posts: 3
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 !

Accepted Solution

  • Michael_0007
    Michael_0007 Posts: 3
    Answer ✓
    i tryed find / | grep ".cnf" :)
    But except those files nothing similar my.cnf
    Looks like mission imposible.Any way , thanks for help.

All Replies

  • Mijzelf
    Mijzelf Posts: 2,858  Guru Member
    250 Answers 2500 Comments Friend Collector Seventh Anniversary

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


  • Michael_0007
    Michael_0007 Posts: 3
    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
    Mijzelf Posts: 2,858  Guru Member
    250 Answers 2500 Comments Friend Collector Seventh Anniversary
    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
    Michael_0007 Posts: 3
    Answer ✓
    i tryed find / | grep ".cnf" :)
    But except those files nothing similar my.cnf
    Looks like mission imposible.Any way , thanks for help.

Categories

Consumer Product Help Center

EnglishTiếng ViệtРусскийไทย中文（台灣）