In use Navicat Import SQL Wrong times for documents :MySql error Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes

Checked the , Turned out to be MySQL Default read executed SQL The maximum file size is 16M, This is me. SQL file 260M, So it can't be carried out in the past

resolvent :

stay MySQL Find the file in the installation directory my.ini, Search for [mysqld], Add a sentence below it

max_allowed_packet=800M

restart MySQL service

Navicat Error in importing data --- 1153 - Got a packet bigger than 'max_allowed_packet' bytes More articles about

  1. Data import report error :Got a packet bigger than‘max_allowed_packet’bytes The problem of

    Data import report error :Got a packet bigger than‘max_allowed_packet’bytes The problem of 2 A solution : 1. Temporary modification :mysql>set global max_a ...

  2. mysql It's a mistake :Got a packet bigger than‘max_allowed_packet’bytes

    as a result of max_allowed_packet The value is set too small . Paste a definition online : max_allowed_packet: Refer to mysql In the process of transmitting packets, the size of packets is defined by the server and the client mys ...

  3. mysql Database import sql Prompt when file “Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes” terms of settlement

    towards mysql Import in database sql When you file , If the file is too large ( A few hundred M), Will prompt "Error Code: 1153 - Got a packet bigger than 'max_allowed_pac ...

  4. MySql error Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes

    I'm using it today Navicat Import SQL Wrong times for documents :MySql error Err [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes ...

  5. 【Mysql】[Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes

    Use today Navicat Error report when importing [Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes The reason is that the database default is 16M The data of , this ...

  6. mysql:1153 Got a packet bigger than ‘max_allowed_packet’ bytes Solutions for

    Backup restore or data import error 1153:Got a packet bigger than'max_allowed_packet'bytes The problem of This problem can have 2 A solution : 1. Temporary modification : mysql> ...

  7. mysql Prompt when importing data Got a packet bigger than 'max_allowed_packet' bytes

    Got a packet bigger than 'max_allowed_packet' bytes error The default may be 2M hold max_allowed_packet Set greater than 5M try , I set it as 160M, transport ...

  8. Import data into database tables , Report errors [Err] [Row1] [Imp] 1153 - Got a packet bigger than 'max_allowed_packet' bytes

    # Add a query to the database , Execute the following command : show VARIABLES like '%max_allowed_packet%'; set global max_allowed_packet = 2*1 ...

  9. mysql Import appears MySQL Error 1153 - Got a packet bigger than 'max_allowed_packet' bytes

    terms of settlement : Just like the .

Random recommendation

  1. Use Animation Realize camera animation

    The plot module of the project was given to me , One of the most important functions is camera rotation and translation , Was going to use Camera Path This plug-in makes , But in view of the project Unity The version still stays at 4.3, Below the required version of the plug-in , In addition, the editor is to hand in ...

  2. Java in Timer and TimerTask Examples of the use of timers and timed tasks

    from :http://blog.csdn.net/kalision/article/details/7692796 These two classes are very convenient to use , It can fulfill most of our requirements for timers Timer Class is used to execute any ...

  3. Layout No collapsible

    center It's not foldable The rest of the , No, title Can't fold   title Using child controls

  4. [ Roof placement ] *p++/*++p difference -linux

    #include <stdio.h> main() { char * s = "123456"; char * p; p = s; printf( "%c\n ...

  5. python Notes (51)

    python Hide the contents of the file by sound , The implementation principle is to insert the contents of the file into different positions of the sound file as the data of the current sampling , At present, it is the encryption and decryption of English text documents #!/usr/bin/env python # -*- codi ...

  6. SQLite3 Use ( Yes dll)good

    1. download sqlite3 Related documents sqlite3.dll.sqlite3.h( Can be obtained from http://download.csdn.net/detail/mingxia_sui/5249070 download ), Added to the project's ...

  7. APP Page design

  8. How to read Java Source code ?

    It is necessary to read this article 3.6 minute . read Java Source prerequisites : 1. Technology base Before reading the source code , We need to have a certain degree of technical support . If you've never learned Java, There is no basis for other programming languages , Come up and nibble < ...

  9. iOS Video development experience

    iOS Video development experience Cell phone than PC In addition to being portable , I think the most important thing is to create multimedia works quickly and conveniently . Photo sharing , Speech input , video recording , Location . A successful mobile phone APP From the product form, there are one or more of these , such as in ...

  10. Latex: solve The gutter between columns is x inches wide (on page x), but should be at least 0.2 inches. problem

    Reference resources : Sample_WCCI.tex Latex: solve The gutter between columns is x inches wide (on page x), but should be ...