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

Error In The Order Of Statements In Batch Exports

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Error In The Order Of Statements In Batch Exports

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • August 5, 2005 at 8:46 pm #18870
      peterlaursen
      Participant

      I can confirm this bug.

      Actually I tried to attach a small zip illustrating it, but it won't let me!

      However I experience that the backupwizard sorts the create statements correctly. Further there is here a CONSTRAINTS_CHECK = 0 -option. But of course this is only available in Enterprise version.

    • August 5, 2005 at 8:49 pm #18871
      peterlaursen
      Participant

      I sent the two small files to Ritesh instead.

    • August 5, 2005 at 9:17 pm #18872
      peterlaursen
      Participant

      Tried with this DB (shown i Access “relations” view”).

      here you will have to set FOREIGN KEYS CHECK = 0 in Backup tool.

      So it probably was a mere coincidence that with only two tables they came in the right order.

      Actually I don't know if this is a bug. There can be DB-design's where no sort order will do and you will have to use FOREIGN KEYS CHECK = 0. A solution could be always using FOREIGN KEYS CHECK = 0 with InnoDB from export tool. However then it must be user's responsibility to always exprot related tables! Quite a difficult choice I believe …

      I have the Enterprise version 😀

    • August 6, 2005 at 7:43 am #18873
      Ritesh
      Member

      You have to check SET FOREIGN_KEY_CHECKS=0 in both the options.

    • August 6, 2005 at 10:35 am #18874
      peterlaursen
      Participant

      I'm ashamed! 🙁

      Totally overlooked that that setting was there too in export tool.

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