I'm wondering how can I backup mysql daily and backup binary log hourly?
I don't know how to write a script to do this(or use etc/crontab?).
Server Fault is a question and answer site for system and network administrators. It only takes a minute to sign up.Sign up to join this community
Have a look at automysqlbackup which takes daily, weekly and monthly backups of your MySQL databases using mysqldump. It also rotates the daily and weekly backups.
I cannot see a reason to take hourly backups of binary log. Better store it on redundant disks if you are worried about head crashes.
Have you looked into mysqldump? It's part of the distribution.
crontab -e (as root or as the user that owns mysql)
Enter the following:
0 0 * * * mysqldump databasename > nameofdumpfile
where databasename is the database to dump and nameofdumpfile should be the whole hierarchy to your desired dumpfile.
The above will dump at midnight daily but you'll want to add qualifiers to suit you.