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
Hi,

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.

Comments

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.