What is the best way to make automated daily backup of MySQL databases and have these backups rotated on a 3 days interval basis?
To be exact, here is what I need to do:
1- Backup Database db_X at 1AM EST into db_X_02_07_13.sql with being todays date.
2- Next day Backup Database db_X at 1AM EST into db_X_02_08_13.sql and Delete the db_X_02_05_13.sql
so that we are keeping total of 3 backups of each DB
I assume the best way to do this is via Crontabs. But just not clear about the exact command for above 2 Steps process.