I have a MySQL database that I need to do weekly backups of.
Basically, I have a web interface that uses PHP where users enter in data and this data is saved in a MySQL database of 3 tables. This data is pretty important and a system failure would cause a lot of annoyance.
The best option would be to have it automatically back up these tables every week. My question is, how do I manage this?