Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Limit Size Of Bulk Inserts

forums › forums › SQLyog › Using SQLyog › Limit Size Of Bulk Inserts

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • June 9, 2011 at 5:53 am #32337
      ashwin
      Member
      Quote:
      I was wondering if the default behavior for “Create bulk insert statement” for a dump could be modified to insert values in blocks of 10 or 50, as the old MySql Administrator GUI Tool did. That is, instead of 1 insert statement followed by a giant block of all rows in the table, have 1 insert statement for every 10-50 rows.

      There is an option in Tools -> Preferences -> General tab -> under Export option- “Max. size (in K:cool: for BULK INSERT statement(s)”. The DUMP (SQL-file) will contain INSERT statements with the (textual) length as you specify here. The option to 'get server default' will use the 'max_allowed-packet' setting for the actual server. Refer attached image.

      NOTE: The size should be specified not larger than the max_allowed_packet setting on the server where you want to restore the dump.

      Regards,

      Ashwin A

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.