Feature: Backup Enhancement

[David DeLella]

The most needed feature of SQLyog is an enhanced scheduled backup. There is currently a feature for backing up individual database and tables, however this does not suite the needs of Enterprise users. Companies often have database servers with many individual databases on each. After researching other backup software, we were unable to find a backup program which could my company's needs. We were looking for an application which would always be running (aka Windows Services) that would control multiple scheduled backup tasks. These tasks could range from individual databases to every database on a selected server. The closest application we could find to match these need was MySQL Auto Backup Professional 2.0. This program allowed for the wasy customization of backup that we required. There was however, minor bugs and software package dislikes which prevent us from switching. Our developers use SQLyog on a daily basis and would like to see this feature enhanced to improve the ability to protect ourselves from data lose. Hopefully we will see this feature enhanced in a future version.

[peterlaursen]

Now you can easy create a .bat file reading like

Code:

sja backupjob_1.xml
sja backupjob_2.xml
…
sja backupjob_n.xml

and schedule that .bat file. It also is very easy to use a text editor to 'search and replace' and thus create the various job files once you got one to use as a 'template'.

However I think that databases of different use and importance should have different 'backup strategy' ? You can then group them into different categories and create a .bat file for each group.

Related FAQ's:

http://webyog.com/faq/24_121_en.html

http://webyog.com/faq/27_35_en.html

[Author]

Posts