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

Tagged: , , ,

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • October 27, 2012 at 9:45 am #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

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