SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Addict
    Join Date
    May 2001
    Location
    Turkey
    Posts
    372
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Got a packet bigger than 'max_allowed_packet' bytes

    SQL query:
    INSERT INTO `cache_menu` (`cid`, `data`, `expire`, `created`, `headers`, `serialized`) VALUES ('links:navigation:tree-data:610a3527b44a3e965a10608687f2c433', 0x613a323a7b733a343a2274726565223b613a3135363a7b693a313b613a323a7b733a343a226c696e6b223b613a33373a7b733a31343a226c6f61645f66756e6374696f6e73223b733a303a22223b733a31363a22746f5f6172675f66756e6374696f6e73223b733a303a22223b733a31353a226163636573735f63616c6c6261636b223b733a313a2231223b733a31363a226163636573735f617267756d656e7473223b733a363a22613a303a7b7d223b733a31333a22706167655f63616c6c6261636b223b733a31373a2273797374656d5f62617463685f70616765223b733a31343a22706167655f617267756d656e7473223b733a363a22613a303a7b7d223b733a353a227469746c65223b733a303a22223b733a31343a227469746c655f63616c6c6261636b223b733a313a2274223b733a31353a227469746c655f617267756d656e7473223b733a303a22223b733a343a2274797065223b733a313a2234223b733a31313a226465736372697074696f6e223b733a303a22223b733a393a226d656e755f6e616d65223b733a31303a226e617669676174696f6e223b733a343[...]
    MySQL said:
    #1153 - Got a packet bigger than 'max_allowed_packet' bytes

    Can someone let me know what this error is ? I get it when I try to import a database file.

    thx.

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    First search result for max_allowed_packet has your solutions:
    http://dev.mysql.com/doc/refman/5.1/...too-large.html

  3. #3
    SitePoint Addict
    Join Date
    May 2001
    Location
    Turkey
    Posts
    372
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by Dan Grossman View Post
    First search result for max_allowed_packet has your solutions:
    http://dev.mysql.com/doc/refman/5.1/...too-large.html
    ok. it says
    If you are using the mysql client program, its default max_allowed_packet variable is 16MB.

    I'm rying to import a 1.7MB file at all. why do I get this error then ?

  4. #4
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,578
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server.
    ^


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
  •