Home

max_allowed_packet size

By nerkn - February 23rd, 2009
Tagged:  

Büyük bir import yapıyorsanız, site taşıyorsanız mysql sızlanabiliyor.
ERROR 1153 (08S01) at line XXX: Got a packet bigger than 'max_allowed_packet' bytes
Eğer server'da mysqld'ye erişiminiz varsa
/etc/init.d/mysqld stop
sonra
mysqld --max_allowed_packet=32M
ve tada artık istediğiniz import'u yapabilirsiniz.
geri normal serverimizi çalıştırmak için

/etc/init.d/mysqld stop
/etc/init.d/mysqld start

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
 888                                              .d8888b.  
 888                                             d88P  Y88b 
 888                                                  .d88P 
 888888   .d88b.   888  888  888  888  888  888      8888"  
 888     d8P  Y8b  888  888  888  888  888  888       "Y8b. 
 888     88888888  Y88  88P  Y88  88P  888  888  888    888 
 Y88b.   Y8b.       Y8bd8P    Y8bd8P   Y88b 888  Y88b  d88P 
  "Y888   "Y8888     Y88P      Y88P     "Y88888   "Y8888P"  
                                            888             
                                       Y8b d88P             
                                        "Y88P"
Enter the code depicted in ASCII art style.

Similar

  • New technique to win olimpics -

    New technique to win olimpics

    By nerkn - July 27th, 2010
    Tagged:  

    At the 1968 Olympics, Dick Fosbury took the athletics world by surprise with an unusual high-jump technique.

  • Printing mysql_error -

    Printing mysql_error

    By nerkn - June 23rd, 2010
    Tagged:  

    This is a code snipped to print mysql error.
    If there is no error mysql_error returns null, thus if evaluates false and there is no output.

  • multiple ON DUPLICATE KEY UPDATE -

    multiple ON DUPLICATE KEY UPDATE

    By nerkn - May 25th, 2010
    Tagged:  

    Here is an example of how to update multiple columns using values supplied in the INSERT statement. This assumes that column 'a' is the unique key.

  • multiple ON DUPLICATE KEY UPDATE -

    multiple ON DUPLICATE KEY UPDATE

    By nerkn - May 25th, 2010
    Tagged:  

    Here is an example of how to update multiple columns using values supplied in the INSERT statement. This assumes that column 'a' is the unique key.

  • php unlink recursive -

    php unlink recursive

    By nerkn - May 19th, 2010
    Tagged:  

    The shortest recursive delete possible.

    <?php
    /**
    * Delete a file or recursively delete a directory
    *
    * @param string $str Path to file or directory
    */

    • Fotoğraf Web