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

SQLyog – how does one schedule a backup?

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › SQLyog – how does one schedule a backup?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • November 8, 2004 at 11:51 pm #8647
      patrickq
      Member

      Hi all,

      I am new to SQLyog, and have a 1GB database with InnoDb tables, and struggling to understand how to schedule an automated backup. I also can't seem to find how to effect a restore based on a scripts file. Details below.

      I quickly found out how to backup my database (via DB->Export Database as Batch Scripts), but can't seem to find how to schedule a regular backup to do that same task on a regular basis. The “Notification service” seems to be geared toward executing queries, not backups.

      Also, I am still looking for the way to take an existing scripts file (generated by the “DB->Export Database as Batch Scripts” command) to effect a restore (preferably, a selective restore where I get a chance to select which table(s) to restore).

      Thanks!

      Patrick

    • November 9, 2004 at 3:30 am #16524
      Ritesh
      Member

      Currently, you cannot schedule generation of Batch Script in SQLyog. The only thing that can be scheduled are:

      • Database Sync Wizard (Tools->Power Tools->Database Sync Wizard)

      • SQLyog Notification Services (Tools->Power Tools->SQLyog Notification Services Wizard)

      With that I would like to say that the above feature is planned for SQLyog 4.1.

      To import a batch script, use Tools->Execute Batch Script…

    • November 11, 2004 at 7:54 am #16525
      Shadow
      Member

      Well, I'm not happy to say, but download MySqlAdministrator from MySql's website and use its scheduled backup. That's what I do currently…

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