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

Compress Backup Files?

forums › forums › SQLyog › Using SQLyog › Compress Backup Files?

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • May 21, 2006 at 6:55 pm #9695
      jalperin
      Member

      Is there a way to automatically compress (e.g. Zip) scheduled backup files? If not, is this a planned enhancement?

    • May 21, 2006 at 7:05 pm #21680
      peterlaursen
      Participant

      there is a way ..

      You can create a batch file that

      1) runs sja

      2) next calls a zip program that can be executed from commandline. Filzip http://www.filzip.com is an excellent (free) one that has command-line option. You can add into an existing archive.

      3) finally execute a 'del' command to delete the .sql file when zipping is done

      it is a .bat with three lines. You can schedule the .bat and not the SJA itself then.

    • May 22, 2006 at 5:50 am #21681
      Ritesh
      Member

      Inbuilt support for ZIP is in the TO-DO list but I cannot guarantee you which version will have this feature. Till then, you can use Peters suggestion.

    • May 22, 2006 at 11:33 am #21682
      jalperin
      Member

      Thanks for the workaround. I'll try that. I think the scheduled backup feature isn't nearly as useful without the compression option because files are often so big. Also, note that phpMyAdmin has had this feature for quite some time.

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