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

Sql Dump For Just Stored Procedures?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Sql Dump For Just Stored Procedures?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • August 16, 2007 at 8:00 am #24688
      peterlaursen
      Participant

      Yes, we have similar requests. I think we will implement in the 6.1 tree.

    • August 16, 2007 at 8:50 am #24689
      peterlaursen
      Participant

      Actually there is a little bit silly consequence of what we are doing now!

      If you have a database without a single table, but lot of ROUTINES, you cannot export anything at all. The program forces you to 'select at least one table'.

    • August 19, 2007 at 11:30 pm #24690
      Simeon
      Member
      peterlaursen wrote on Aug 16 2007, 08:50 PM:
      Actually there is a little bit silly consequence of what we are doing now!

      If you have a database without a single table, but lot of ROUTINES, you cannot export anything at all. The program forces you to 'select at least one table'.

      While you're there… would it be possible to add a further check box to turn off the “DEFINER” part of the statement? I develop locally (where I have permissions to do anything) and then deploy onto a third party hosted server (where I have the bare minimum permissions) and currently I 'find and replace' the DEFINER sections to remove them.

      Not a biggie, but it would be nice to have.

    • August 20, 2007 at 8:01 am #24691
      peterlaursen
      Participant

      An option to turn of DEFINER is a good idea when you are working with hosts when the same users do not exist!!

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