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 is empty.
Viewing 0 reply threads
  • Author
    • #12831

      As you correctly stated in your blog there is an issue with large Bulk inserts and the max_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.


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


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