I’m looking for a bash backup script that will do the following:
Use mysqldump to dump the data into individual files, one for each table.
Tar and compress the dump, removing the individual files.
Store the tar file using a date format, something like “backup-yyyymmdd”.
Remove files that are 7 days or older
I’m familiar with mysqldump, less familiar with using bash.