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

Export Data As Sql Statements – No Line Feed

forums forums SQLyog SQLyog: Bugs / Feature Requests Export Data As Sql Statements – No Line Feed

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #19437
      Ritesh
      Member

      Are you using Create Bulk Insert Statements?

    • #19438
      sdozono
      Member

      Yes. That's right.

      If that 'Create Bulk Insert statements' checkbox is OFF, SQLyog will create a dump with line feeds.

      I tested phpMyAdmin.

      It will make a bulk dump with line feeds.

      It's like this:

      INSERT INTO `languages` VALUES (1, 'English', 'en', 'icon.gif', 'english', 1),[line feeds]

      (2, 'Deutsch', 'de', 'icon.gif', 'german', 2),[line feeds]

      (3, 'Espanol', 'es', 'icon.gif', 'espanol', 3),[line feeds]

      (4, 'Japanese', 'ja', 'icon.gif', 'japanese', 4);[line feeds]

    • #19439
      Ritesh
      Member

      Hmmm. Nice.

      I have added it in the TO-DO list. Will be implemented in v4.2 BETA 6.

    • #19440
      peterlaursen
      Participant

      Then I shall repeat my request that the bulk size is user configurable.

      Reason for that:

      importing to my ISP w/o bulks is incredible slow. But the default bulk size is much too big for the configuration (fails to of three times) I would like an option to choose for instance 200 K as bulk size. That is reasonable fast and safe too.

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