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

Quoting Problems with Execute Batch Scripts

forums forums SQLyog Using SQLyog Quoting Problems with Execute Batch Scripts

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • #8831
      zzapper
      Member

      Hi,

      I often use Export database as Batch Scripts followed by Excute Batch Scripts as a way of transferring the DB or alternatively backing it up.

      The Export runs fine, but when I come to execute the Batch File on a particular Database I find the fields are bounded by single quotes (as is normal), but that the text within also contains un-escaped quotes of the sort

      it's, O'Reilly and Joe's Diner. These single quotes “break” the execution. First of all I cannot understand why these single quotes aren't a problem in the actual live database. Then should I be configuring YOG differently?

    • #17116
      Ritesh
      Member

      Which version of SQLyog are you using?

      4.1 BETA or 4.0x?

    • #17117
      zzapper
      Member

      Ritesh,

      the freshly brewed 4.1.Beta

      BTW I have just successfully used Copy DB to a different DB/HOST.

      SQLyog Enterprise v4.1 BETA

    • #17118
      Ritesh
      Member

      Thx for the report.

      I have forwarded the issue to my development team. The bug (if there are any) will be fixed in the next BETA.

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