View: mysql dump with delete more then 3 backups

1. mysql dump with delete more then 3 backups
   4 months ago by sx
   1. DATUM=`date '+%Y-%m-%d'`
   2. mysqldump -u USER --password=PASSWORD DATABASE TABLE > /home/backup/db.sql
   3. gzip /home/backup/db.sql
   4. mv /home/backup/db.sql.gz /home/backup/db-${DATUM}.sql.gz
   5. find /home/backup/ -mtime +2 -type f -print0 | xargs -0 rm
   mysqlphp
   View source