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

Dump Created With Incorrect Line Endings?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Dump Created With Incorrect Line Endings?

  • This topic is empty.
Viewing 12 reply threads
  • Author
    Posts
    • July 27, 2010 at 3:34 pm #12055
      larsen
      Participant

      Hi,

      I´m using SQLyog Community 8.6 Beta 2. When I create a dump from a Linux server on my Windows PC, I suppose the line ending format is not correct:

      When I open the dump in UltraEdit (14.10):

      – File is shown as “UNIX”

      – There are block-characters at every line end

      When I set UltraEdit to automatically detect UNIX files, I get asked if I want to convert the file to DOS upon opening it:

      – no -> block-characters

      – yes -> no b-c

      When I open the file in Notepad++ (5.3.1) it is:

      – shown as MAC

      – there is always an empty line after a “regular” line

      Therefore, I guess the line endings are not quite correct!?

      Cheers

      Lars

    • July 27, 2010 at 6:46 pm #31164
      peterlaursen
      Participant

      And if you open in a HEX-editor what linebreak-characters do you see?

    • July 28, 2010 at 7:35 am #31165
      larsen
      Participant

      That´s strange: There is “0d 0d 0a” after most lines except for the line with the SQLyog version and each line for a field definition in the create table statement where it´s just “0d 0a”.

      So, I guess as the first linebreak-character is “0d”, UltraEdit recognizes the file as UNIX and then of course displays blocks for the “0d 0a”.

    • July 28, 2010 at 8:16 am #31166
      nithin
      Member

      Thanks for the info.

      We will check this in detail.

    • July 28, 2010 at 8:39 am #31167
      larsen
      Participant

      Should have posted the dump in the first place…

    • July 29, 2010 at 12:14 pm #31168
      nithin
      Member

      It has been fixed now. We will release 8.6Beta3 with this fix on next week.

    • July 29, 2010 at 12:29 pm #31169
      larsen
      Participant

      thx!

    • August 3, 2010 at 2:02 pm #31170
      nithin
      Member

      We released 8.6Beta3 with this fix.

      8.6Beta3 change-log

      Please download and verify in your environment.

    • August 3, 2010 at 2:12 pm #31171
      larsen
      Participant

      Mostly fixed, but there is still one in the last line of that block:

      Code:
      /*
      SQLyog Community v8.6 Beta3
      MySQL – 5.0.51a-24+lenny4-log : Database – mysql
      *********************************************************************
      */
    • June 29, 2011 at 10:39 am #31172
      larsen
      Participant

      *push*

      I still can see a square after the first comment is closed with “*/”

      Version 9.10

    • June 29, 2011 at 1:10 pm #31173
      peterlaursen
      Participant

      1) Are you able to attach a small dump illustrating this?

      2) Does this issue cause failure to import or is it more 'cosmetical'?

    • June 29, 2011 at 1:27 pm #31174
      larsen
      Participant

      1) zip includes dump and a screenshot from UltraEdit

      2) I think it´s more cosmetical

    • June 30, 2011 at 10:53 am #31175
      peterlaursen
      Participant

      Confirmed. There is a redundant 'carriage return' character. Will be fixed of course.

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