What is the best way to backup my database on a regular basis?

I put my script on github:

https://github.com/sierracircle/website-backups

if you are interested…

I have a script that you can run on a cronjob that will make a dump of your databases, and also backup your website files. The script will backup to wherever you want, but lately I have been backing up to Amazon S3 buckets. If your droplet ever crashes it is nice to have complete backups of recent databases and website files on a seperate location.

I will work on the tutorial today.

If you want to do prep, you can:

-create an AWS account: https://aws.amazon.com/ -create a database user that will only be for backing up stuff. You can give that user the following global permissions: select file show view super process reload show databases lock tables replication client