To backup Database once in a week
Minute |
Hour |
Day |
Month |
Weekday |
Command |
0 0 * * Sat /usr/bin/mysqldump -u<usernam> -p<password> <dbname> | bzip2 -9 -c ><full path to save>/<output file name>$(date +"\%d_\%m_\%Y-\%H:\%M:\%S").sql.bz2
To delete files older than 2 weeks
26 11 * * 6 find <full path to save>/<output file name>*.sql.bz2 -mtime +8 -exec rm {} \;
Backup files once a week
ref
find <full path to save>/ -name 'log*' -and -not -name '*.bz2' -ctime +7 -exec bzip2 -zv {} \;
Modified(Not tested)
find <full path to save>/ -name 'log*' -and -not -name '*.bz2' -mtime +7 -exec bzip2 -9 -c ><full path to save>/<output file name>$(date +"\%d_\%m_\%Y-\%H:\%M:\%S").files.bz2 -zv {} \;