I have created a site on a dedicated server with a rather large (and growing) MySQL database. I'm responsible for my own backup of the database but I'm not sure how I should go about doing it. I've looked at phpmyadmin and I can see how I could just export it nightly by hand but that is clearly a big nuisance. How could I automate the backup process? Does anybody have any good links to tutorials on backing up MySQL databases nightly?
