Backup Entire Server

[Greg]

Hello all,

I am currently thinking of using SQLyog as the primary method for backup on our three webservers all running mySQL. Each server has between 10-30 databases on it. I have attempted to do my due dilligence, and installed the trial. Every thing seems to work pretty well.

The two options that i am particuarly interested in are as follows:

1) ability to back up all databases on a server without having to setup a seperate scheduled backup for each

2) the ability to zip the files when complete with the scheduled backup. I know i could setup a script to do that but it would be nice if SQLyog did it its self.

Am i missing something, or are these options not available.

Thanks,

Greg

[peterlaursen]

They are not available wit h SJA itself. However you can use a windows bat file.

that bat file will then have one line for each database like

SJA job1

SJA job2

etc.

finally you will need to use a zip program that can be called from command line and delete the originally file once it is added to the zip archive

Filzip (www.filzip.com) for instance can do this.

So

SJA job 1

filzip

del … (delete file now that is is added to zip)

SJA job 2

filzip

del … (delete file now that is is added to zip)

etc.

And then the bat file itself can be scheduled.

more examples of the use with SJA and .bat -files: http://webyog.com/faq/27_35_en.html

[Author]

Posts