Right now i have a cron job that dumps my database twice a day. Right now its fine because my DB is < 100mb. I have limited space on the server (also i'd like to reverse space for other things). How do i make incremental backup with mysql? i would like to do it every 3-4 hours and a full dump on a weekly basis.
How do i do this? Also i hear using a 'binary log' is good but i am unsure how to do that properly.
Many links is welcomed.