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

Copy Table Structure/Data doesnt copy extras

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Copy Table Structure/Data doesnt copy extras

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • April 26, 2003 at 3:27 am #7872
      wolven
      Member

      When you do a Table Structure/Data copy command, the information under extra's isnt copied ( Auto_Incriment, etc )

      Example:

      Column Information For – wolven_AoStuff.BugAttachments

      Field Type Null Key Default Extra

      AttachmentID bigint(20) MUL (NULL) auto_increment

      BugID bigint(20) 0

      Filename varchar(255)

      ctype_primary varchar(255)

      ctype_secondary varchar(255)

      Body longblob

      ^^ before copy

      Field Type Null Key Default Extra

      AttachmentID bigint(20) MUL

      BugID bigint(20) 0

      Filename varchar(255)

      ctype_primary varchar(255)

      ctype_secondary varchar(255)

      Body longblob

      ^^ After copy

    • April 26, 2003 at 12:09 pm #14156
      Ritesh
      Member

      Hello

      Are you using the option DB->Copy Database To Different Host/DB….?

      I tried the above option and it is copying the extra information as required 🙂

    • May 1, 2003 at 3:52 am #14157
      wolven
      Member

      No… im right clicking table, and doing 'copy table structure / data'.

      wolven

    • May 1, 2003 at 9:00 am #14158
      dany
      Member

      Bug confirmed,

      whilst “DB->Copy Database To Different Host/DB” works fine.

    • May 1, 2003 at 9:34 am #14159
      Ritesh
      Member

      Hello

      Thanks for the info 😀

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