Monday, February 7, 2011

MySql dump with Cronjob

0 0 * * 0 /usr/bin/mysqldump -uroot -p'PASS' DBName > /path/DB_backup/$(date +\%Y-\%m-\%d_\%Hh\%M).sql

example output file:
2011-02-06_00h00.sql