If we stick to SQLyog, then the “Database Syncronizaion Wizard” is the righttool for you. SQLyog uses a separete executable (sja.exe) to perform these tasks. You can determine from which db to which db do you want to perform the sync, you may add criteria to restric unneeded data flow, and sync sessions can be scheduled via Win's built-in scheduler.
Its greates advantage is, that you have a “live” copy of the data. A cach is that the target database must conform to the source one (at least the synced tables must match).
SQLyog does not offer any more backup techniques that could be scheduled. Of course, you may use Win's scheduler to launch for example mysqldump in a predetermined time.
If you use CSV as a backup format, then you'll have to store the SQL statements responsible for creting the tables elsewhere, thus reducing the required storage place, but complicating the db maintenance (just imagine that you change the structure of your db, but forget to commit these changes to the SQL scripts in the backup). SQL format, however, uses complete SQL statements that create the tables and insert data. MySqlAdministrator offers an interface to schedule such backups.
