Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

backup script using sqldump and table files

iberkneriberkner ContributorInactive User Role Beginner

I'm looking for a bash backup script that will do the following:

1. Use mysqldump to dump the data into individual files, one for each table.

2. Tar and compress the dump, removing the individual files.

3. Store the tar file using a date format, something like "backup-yyyymmdd".

4. Remove files that are 7 days or older

I'm familiar with mysqldump, less familiar with using bash.


Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.