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

Sql Dump Export Tables, Text Columns Converted To Blob?

forums › forums › SQLyog › Using SQLyog › Sql Dump Export Tables, Text Columns Converted To Blob?

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 21, 2013 at 2:22 pm #12954
      capsizeno4
      Member

      Hello,

      I am exporting tables from sqlyog as a data dump, SQL Structure and Data, and in the sql files created all my columns that are defined as Text columns are being converted to Blob.

      ** Edit ** — also wanted to note that the data in these new blob columns are now truncated.

      Is there a setting that I am missing that is making this happen? I wouldnt expect (or request) a column format to be changed on export, and need the column definitions to be retained as defined.

      Thanks!

    • March 22, 2013 at 4:50 am #34256
      sathish
      Member

      Hello,

      We tried exporting a table as sql dump with a text field, but unable to reproduce this in the current version(v11.01).

      Could you please let us know which version of SQLyog are you using(Help->About)?

      The MySQL server version( Select Version(); )

      Also please paste the create table statement here?

      Regards,

      Sathish

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.