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

Using Sqlyog To Export To Csv: Command Line?

forums › forums › SQLyog › Using SQLyog › Using Sqlyog To Export To Csv: Command Line?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • September 13, 2006 at 7:32 pm #9871
      Shawn
      Member

      I recently purchased SQLYog Enterprise. For me the best feature so far is the Notification Services Wizard to set up scheduled emails of the results of SQL queries. But I've found that not all mail clients display the HTML email properly.

      So I noticed that the SQLYog GUI offers the functionality of exporting a resultset to CSV.

      My question is, is it possible to schedule that task from the command line using SJA.exe and an XML-based config file, similar to how the Notification Services Wizard schedules jobs?

      If so, I could schedule the export of a CSV file daily and then just use some mechanism outside of SQLYog to email it as an attachment.

      Any suggestions are greatly appreciated!

      Best,

      Shawn Syms

    • September 14, 2006 at 2:32 pm #22418
      peterlaursen
      Participant

      “Is it possible to schedule that task from the command line using SJA.exe”

      Yes.

      You can use 'Notifications Services” and the SQL to execute must be a “SELECT … INTO OUTFILE …”

      that is exactly what SQLyog CSV-export does: http://webyog.com/faq/28_73_en.html

    • September 20, 2006 at 11:20 pm #22419
      Shawn
      Member

      Thank you!

      Best,

      Shawn

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