Tag: mysql

  • Automated mysql cronjob backups

    This will run ever day at 11:00: 0 11 * * * mysqldump -u digitaliq-production digitaliq-production –password=password123 > “/var/www/backups/dbdump_$(date +\%$).sql” Delete files after 5 days: find . -type f -mtime +5 -name ‘*.sql’ -execdir rm — ‘{}’ \;