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

Occasional Corrupts saving as batch file via tunne

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Occasional Corrupts saving as batch file via tunne

  • This topic is empty.
Viewing 8 reply threads
  • Author
    Posts
    • March 21, 2005 at 4:33 pm #8864
      zzapper
      Member

      Hi,

      I'm getting occasional corrupts when “saving DB as Batch Files” ie 3 bad inserts in 45,000 using a tunnelled connection.

      Is this because I'm using a Beta (4.1) or unavoidable timeout problems?

    • March 21, 2005 at 4:42 pm #17205
      Ritesh
      Member

      What do you mean by 3 bad inserts?

    • March 21, 2005 at 5:25 pm #17206
      zzapper
      Member

      eg

      insert into `db73723442`.`downloadtrials` values ('3032','cashbookwin','Neil','fred Software Ltd','[email protected]','07977464839');;

      insert into db73723442.pdownloadtrialsp values <<==== ERROR HERE <<==== insert into `db73723442`.`downloadtrials` values ('3033','payroll','Steve Pass

    • March 21, 2005 at 6:40 pm #17207
      Ritesh
      Member

      Can you mail me the corrupted SQL file in question? Part of it which describes the error will be nice too.

    • March 21, 2005 at 9:13 pm #17208
      zzapper
      Member

      Ritesh,

      It's client data so I dont' feel I can send it to you.

      But I've noticed:-

      0) The Rogue inserts always end with “values”

      1) the rogue inserts are superfluous ie they are preceded and followed by good inserts eg

      insert into `db73723442`.`downloadtrials` values ('1844','cashbookwin','…..'01614831435');;

      insert into db73723442.pdownloadtrialsp values

      insert into `db73723442`.`downloadtrials` values ('1845','cashbookwin','…….'

      2) The previous good insert always has ;; (double semi-colon)

      3) The quotes round the table name are replaced by a pair letter of letters sometimes p sometines x

    • March 21, 2005 at 10:10 pm #17209
      Ritesh
      Member

      This is indeed strange. 😮

      Are you able to duplicate the problem with direct connection?

    • March 22, 2005 at 9:05 am #17210
      zzapper
      Member

      Ritesh,

      I can duplicate this from my local copy!!

      I 'm using your latest beta.

      I find the error by searching for lines ending

      valuess+$

      insert into db73723442.pdownloadtrialsp values

      insert into db73723442.pleaddetailsp values

      insert into db73723442.pwebsiteproductsp values

      insert into db73723442.pdownloadtrialsp values

      insert into db73723442.pleaddetailsp values

      insert into db73723442.pwebsiteproductsp values

    • March 22, 2005 at 11:13 am #17211
      Ritesh
      Member

      Are there any special characters in the rows which are getting corrupted?

      I just took a backup of our main database and everything was fine.

    • March 22, 2005 at 7:37 pm #17212
      Ritesh
      Member

      Bug confirmed.

      Will be fixed in the next BETA.

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