Hi. I need a free GOOD utility that I can upload to my server that will back up my database ever 5 or 10 minutes by overwriting the last previous backup so that I don't end up with thousands of sql files. Anyone know of any good solution?
This is very easy, the tools for this are already on your server 1. You need to setup a cron job to do your backup. Info on this here: https://en.wikipedia.org/wiki/Cron 2. Get the Cron to run a database backup every 5 or 10. It will overide the previous one For MySql use mysqldump
I use the tools that come with sqlyog (which is not free). Worth every penny - especially if you are backing up that often.
If you keep only one copy and overwrite it that often, what happens when it actually crashes or breaks? Will you be able to get to it and fix it within 10 minutes? No. All you will have is one broken copy. Keep multiple copies spaced out in time.
AutoMySQLBackup is a shell script that will create Daily, Weekly and Monthly backups of one or more of your MySQL database.