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

Editor Stop On Error?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Editor Stop On Error?

Tagged: 

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • January 6, 2016 at 4:52 pm #13474
      joviel
      Member

      Using SQLYog 12.15 Ultimate as a DBA.  I would like to use it to run release scripts against our production database.  However, unlike SQL Workbench SQLYog doesn’t seem to halt script execution on error, simply moves on the next command in the script.  Can this behavior be modified?  The only work-around is to run scripts line-by-line.  This is obviously unacceptable for large scripts.

       

      Thanks,

       

      Scott Uhrick, Teladoc

    • January 15, 2016 at 8:15 am #35615
      Sibin A S
      Moderator

      Hello Joviel,

       

      You can use the “SQL Scheduler and Reporting Wizard” from the “Powertools” menu which provides the option to “Exit immediately” or “Continue with next query” when an error occurs while executing scripts. 

       

      You can also schedule the execution to run immediately or later. Please refer  the doc >> http://sqlyogkb.webyog.com/article/306-choosing-what-to-do

       

      SQLyog lets you either ‘Send the query results to an email’ or ‘Execute scripts and also send an email on error’ with this option.

       

      Regards,

      Sibin

    • January 22, 2016 at 5:48 pm #35616
      suhrick
      Member

      Sibin,

       

      That is fine for the scheduler, but what about halting on error in the editor?  That is how I (and most people) run scripts.  I would like it to halt on error there. 

       

      Thanks,

       

      Scott

    • January 29, 2016 at 1:16 pm #35617
      Sibin A S
      Moderator

      Hello Scott,

       

      We have added your request into our issue tracker, here >> https://github.com/webyog/sqlyog-community/issues/2097. 

       

      We have replied in the ticket created by you.

       

      Regards,

      Sibin 

    • May 5, 2016 at 2:07 pm #35618
      Sibin A S
      Moderator

      Hi,

       

      We have added this feature you requested in the SQLyog 12.2.2 release. Please refer the blog post for more details, which can be found here >> http://blog.webyog.com/2016/05/05/sqlyog-mysql-gui-12-2-2-released/

       

      Regards,

      Sibin

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