Simple Mysql backup script what rotate the backups every 30 days?07.12.13

backup script what create a mysql db backup and delete all older backups than 30 days. so the backups are rotation for last 30 days. 1. create a folder dbBackup 2. create inside the dbBackup folder the subfolder backups 3. create inside the dbBackup folder the file dbBackup.sh file and give it execute permissions. #!/bin/bash user=DBUSER password=MYPASSWORD database=DBNAME time=`date +%Y-%m-%d_%H-%M-%S` mysqldump -u $user -p$password $database > "backups/${database}_${time}.sql" gzip "backups/${database}_${time}.sql" find backups/* -mtime +30 -exec rm {} \; 4. create the cron job for the script ..... 07.12.13

http://www.howtogeek.com/howto/ubuntu/delete-files-older-than-x-days-on-linux/

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024