Results 1 to 1 of 1

Thread: Got a packet bigger than 'max_allowed_packet'

  1. 06-24-2011, 02:12 AM #1
    kaustubh_s
    kaustubh_s is offline Member
    Join Date
    Sep 2010
    Posts
    59

    Default Got a packet bigger than 'max_allowed_packet'

    The error given below may be received while importing / restoring databases.
    ERROR 1153 (08S01) at line xxxx: Got a packet bigger than 'max_allowed_packet' bytes

    The default value of max_allowed_packet is 16MB in mysql database server.
    This value is falling short for the restoration of database. We can set it's value as per
    our need.

    1) vi /etc/my.cnf

    [mysqld]
    max_allowed_packet = 32M
    2) restart mysql service to implement this change.

    3) Now the datbase must get restored without any problem .
    Last edited by kaustubh_s; 06-24-2011 at 02:19 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules