Powered by eUKhost®

Announcement

Collapse
No announcement yet.

Got a packet bigger than 'max_allowed_packet' bytes

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Got a packet bigger than 'max_allowed_packet' bytes

    Hi.

    I am getting this error when i try to import a 11mb db : ERROR 1153 (08S01) at line 15255: Got a packet bigger than 'max_allowed_packet' bytes

    I was trying to import it via phpmyadmin and directly via ssh with this command (mysql -u username -p -h localhost dbname < dbname.sql) but it's the same.

    Someone have a clue on what i shall do to increase the 'max_allowed_packet' value ?
    I've tried stopping the sql and starting it with a bigger max_allowed_packet but i get this error (error: 'Access denied for user 'root'@'localhost' (using password: YES)')

    I am on L-VPS-01 and i use plesk.


    Thanks

  • #2
    Dear Mihai

    I have increased max_allowed_packet to 16MB in /etc/my.cnf
    Please try to import database now and let us know about the result.
    Alan V
    VPS Support Team

    Comment


    • #3
      It worked.



      Thank you Alan.

      Comment

      ban-img
      Working...
      X