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

Feature Request: "maximal Length Of Created Query" To Limit Si

forums forums SQLyog SQLyog: Bugs / Feature Requests Feature Request: "maximal Length Of Created Query" To Limit Si

This topic contains 1 reply, has 0 voices, and was last updated by  limex 6 years, 2 months ago.

  • Author
    Posts
  • #12831

    limex
    Member

    As you correctly stated in your blog there is an issue with large Bulk inserts and the max_allowed_packet:

    http://blog.webyog.c…allowed_packet/

    Why don't you introduce a setting similar to “Maximal length of created query” in phpmyadmin? It limits the size of one extended insert and therefore splits the inserts in multiple ones.

    This is pretty great if you have to migrate a large table to a different server, but max_allowed_packet on the target server limits the bulk export (meaning use of extended inserts). Sure you could disable the extended inserts, but the migration takes a lot longer. In my case factor 10.

    So:

    Please introduce this setting to the “Backup Database as SQL Dump” and “Copy Database to a different Host/Database”

    Thanks

  • #33918

    peterlaursen
    Participant

    The setting is there. Please refer image

    [attachment=1825:bulk.jpg]

    Also read this FAQ:

    http://faq.webyog.com/content/24/101/en/about-chunks-and-bulks.html

    (and note that if you use 'scheduled backup' / SJA backup the setting is specified for each job independently (in the wizard and the job file))

  • #33919

    limex
    Member

    Ooops.

    Totally missed that. Thanks a lot

You must be logged in to reply to this topic.