How to automatically backup all MySQL databases zip them and delete backups older than n days on windows with a batch file

How to automate MySQL backups with a .bat file on a Windows  server. Typically we have used the backup facility built into MySQL administrator, which unfortunately has now reached end of life.  While it worked well it had some major shortcomings. For example once you created a scheduled backup it would only include the databases you told it to at the time of creation.  Well, if you are like us and …