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

Export Database as Batch File?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Export Database as Batch File?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 26, 2004 at 4:17 pm #8450
      csyers
      Member

      Just started working with SQLyog and have run into a couple

      of glitches:

      1) When exporting a database structure,

      the “CREATE TABLE”s are written out in lexical order.

      However, if any PK/FK relationships exist, the tables

      must be reordered for the script to run properly.

      Is there a better way to do accomplish this (a MySQL

      utility perhaps)? Or could E-Rs ordering be considered

      as a future enhancement?

      2) Are there any plans to support stored procs/fns

      ( I realize this is Alpha… )

      Thanks,

      – Chuck

      Thanks,

    • May 26, 2004 at 4:53 pm #15887
      Ritesh
      Member

      Check the option:

      “Set FOREIGN_KEY_CHECKS=0” in Export As Batch Script dialog.

    • May 26, 2004 at 8:21 pm #15888
      csyers
      Member

      Thanks!

    • May 27, 2004 at 8:30 pm #15889
      Shadow
      Member

      Support for MySql stored procedures are planned for SQLyog MAX. v3.7 however is capable of connecting to MySql 5.0, but it does not offer any GUI tool for accessing stored procs, you have to deal with them using the SQL window.

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