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

Automate batch dump

forums › forums › SQLyog › Using SQLyog › Automate batch dump

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • December 6, 2004 at 11:21 pm #8687
      noob
      Member

      I have successfully created a .sql file utilizing the “Export Data as Batch Scripts” from development server and have also successfully “execute batch file” the resulting script into a ISP hosted production database. (ISP host does not allow remote access to mySQL server) I would like to schedule the above process, but I do not see a way to do so. We need to update the tables on ISP hosted server every night. Could you please help? Thank you in advance.

    • December 7, 2004 at 8:20 am #16651
      Ritesh
      Member

      Have you tried “Tools->Power Tools->Database Synchronization Wizard…”?

    • December 8, 2004 at 7:01 pm #16652
      noob
      Member

      Yes I have tried using the sync tool, but it takes hours to finish synching (I am using http tunneling). So I suppose there is no scheduling capability for batch file execution utilizing sqlyog? Thank you for your time and any help you can offer!

    • December 9, 2004 at 3:30 am #16653
      Ritesh
      Member

      Scheduled backup is in the TO-DO list of v4.1.

      Scheduled import of batch file is in the TO-DO list of v4.2.

    • December 9, 2004 at 11:42 am #16654
      Shadow
      Member

      Until these versions are complete, you could try MySqlAdministrator from MySql. It's a free MySql server management tool which is capable of executing scheduled backups and restores.

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