I'm currently running a site with a huge 20GB InnoDB MySQL database on Windows 2003/IIS. My method of backup is to simply stop the MySQL service and make a copy of the "data" directory. However, this results in downtime and isn't easily automated.
Does anyone have a better solution so that I could make a constant backup whilst live? I can't afford the InnoDB live backup tool, but there must be other ways around it?