Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Usually you deploy an existing maintenance script which takes care not only of taking the dump (trivial), but also of deleting the old backup files, naming them accordingly, handling various possible failures etc etc. Eg. I use backup-manager and I'm quite pleased with it.

SQLyog has scheduled backup feature using this you can take periodic backup on certain time interval also there is an option to zip file added advantage is it has got notification if backup fails you will get notification along with failure cause as well.