Looking For A Backup And Keep Old Backups

[eddierosenthal]

I would like to know if it is possible using SQLyog to schedule regular backups, and keep the backup data for several days.

So instead of doing a regular replication using the powertool feature + tunneling, which works fine, i would like to try to see

how to keep backup data for greater periods of time than just one day. This would probably be some sort of export to sql file, from

the remote server to the local client, or even from remote to remote directory with date suffixes for example.

I guess if there is no solution that i can make using SQLyog, then i could create a batch file using cron on the remote server.

thanks in advance

eddie rosenthal

[peterlaursen]

Well .. yes – if I understand!.

Use the 'scheduled backup' feature (from 'powertools' menu). In the wizard there is an option to add a timestamp to the file name. And the ZIP option will probably be useful too. You may do so on you local machine or on the server using SJA for Linux.

FAQ links: http://webyog.com/faq/category/25/sqlyog-job-agent-sja.html

[eddierosenthal]

'peterlaursen' wrote:

Well .. yes – if I understand!.

Use the 'scheduled backup' feature (from 'powertools' menu). In the wizard there is an option to add a timestamp to the file name. And the ZIP option will probably be useful too. You may do so on you local machine or on the server using SJA for Linux.

FAQ links: http://webyog.com/faq/category/25/sqlyog-job-agent-sja.html

[eddierosenthal]

yes that was it – precisely.

thanks again!

[Author]

Posts