I feel like such a dumb*** because I don't know how to make automatic database backups.
I would love to make backups every 3 days or so. Perhaps 3 times a week would be good, not daily though.
I'm using MySQL and Windows and my current method of database backing is to do it manually. I navigate to the mysql data directory, and copy and then paste it onto a CD of mine.
I hate how I have to manually do this all the time. I tried Windows scheduled task manager to create a backup of the mysql data directory but its a no go. Somehow it always fails when trying to back it up.
Is there any other alternatives?