Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    96

    database restore problem

    hello
    i been trying to restore my database but getting this error

    ERROR 1153 (08S01) at line 36: Got a packet bigger than 'max_allowed_packet' bytes
    i have changed the max allowed packet as this you can see

    max_allowed_packet = 10000000000000000000000000006400000000000000000000 0000000000000000000M
    still giving me same error. could you please tell me how am i going to restore my database.
    it is a large database has gos nearly 3 million message and has'nt got any attachment in it. I don't know what should i do please give me an idea


    thanks.

  2. #2
    Join Date
    Mar 2007
    Location
    UK
    Posts
    89
    Presumably you're using MySQL (?)
    What version?


    The first google result gives a number of suggestions (read the user comments):
    http://dev.mysql.com/doc/refman/5.0/...too-large.html


    i have changed the max allowed packet as this you can see

    Quote:
    max_allowed_packet = 10000000000000000000000000006400000000000000000000 0000000000000000000M
    There is a 1GB limit on the packet size - I'm surprised that MySQL didn't start spitting errors when it encountered your enormously big number. Have you checked your logs?

    Did you restart the daemon so that your config changes would take effect?
    Did you increase the packet size on both the server and the client?

  3. #3
    have you tried setting the buffer size:
    set-variable=record_buffer=16M

  4. #4
    Join Date
    Apr 2005
    Location
    Cochin
    Posts
    2,446
    In /etc/my.cnf change the max_allowed_packet value to a higher one than the default. It should work

    Eg :

    [mysqld]
    max_allowed_packet=16M
    Sam
    Supportlobby.com - Expertise in Windows/Linux server support, IaaS and PaaS Management
    Spiralbean.com - Custom Software Development
    Email: exec @ activelobby.net | Skype: unni_active

Posting Permissions

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