Powered by BlogCFM http://www.dougboude.com/blog <p><font size="3">In setting up a new IIS7/Windows 2008 server, I had a need to automate the backup of my MySQL database and so pieced together a little batch file that I then scheduled via the Task Scheduler. The file first removes all backup files that are more than a week old, then performs a sql dump and finally zips the dump. Files are named according to the date and time they were created. Anyway, it took me quite a while to find all the pi http://www.dougboude.com/blog/1/2009/09/7A.Batch-Script-to-Backup-MySQL-Database.cfm 2009-09-17T09:30:00-05:00 goog,scripts, code snippets,placeblogger <font face="Arial" size="3">(to skip to the very heart of this post, <a href="#moral">click here</a>. otherwise humor me and read until you get to it&nbsp;<img src="/blog/FCKeditor/editor/images/smiley/msn/regular_smile.gif" alt="" /> )<br /><br />So I was sitting there working on a CF-based resume builder app when my boss walks in and asks me to take over responsibility for our company's database and then implement a solid backup plan and polici http://www.dougboude.com/blog/1/2009/04/Resolution-to-Mysterious-Bash-Script-Error.cfm 2009-04-10T16:22:00-05:00 goog,scripts, code snippets,placeblogger,SQL,rant