Weekly overwriting cron script ?

[ThorstenA]

I have to setup a cron scrypt that backups my database and overwrites every week. I once had a mysql script line that writes every day a backup with the name of the database + day (for example myforum_monday) and therefore overwrites every week. Do you know how to do that?

[ThorstenA]

Here it is

mysqldump --user=xxxxxxx --password=xxxxxxxx --all-databases >/.../`date +%u`.sql

[Paul M]

This will do the job for you ;

https://vborg.vbsupport.ru/showthread.php?t=126925

One of the options in the config is the date format - if you set it such that it's just Monday/Tuesday etc then it will overwrite any existing backup of the same name.