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

Create Sql Dump: Don´t Use "create Table"

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Create Sql Dump: Don´t Use "create Table"

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • June 29, 2011 at 10:43 am #12368
      larsen
      Participant

      It´s already possible to prevent the insertion of “USE database” and “CREATE database” statements into a SQL dump.

      Could you add the same for “CREATE TABLE” and also add “IF NOT EXISTS” to the dump when it is used?

    • June 29, 2011 at 1:05 pm #32373
      peterlaursen
      Participant

      Why? We have the option to export structure only, data only or both? If you want to export and import to another database will not the 'data only' option do?

    • June 29, 2011 at 1:10 pm #32374
      larsen
      Participant

      Hmm, you´re right. I didn´t think of that or didn´t notice it at that point.

    • August 18, 2011 at 1:51 pm #32375
      frankf
      Member

      Where is the “Export data only” option??

      I have the enterprise version and I only see two export options: “structure and data” or “structure only”.

    • August 18, 2011 at 2:20 pm #32376
      peterlaursen
      Participant

      You must be using an old version. See how this dialog looks in 9.2:

      [attachment=1613:this.jpg]

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