The automysqlbackup solve it 99% of the problems I had with backups of my local databases.
The only thing that could not properly set up in direct scritp was the life cycle of the backup. For example:
- I like to keep up daily for 60 days
- The last 20 weekly backups
- The last 12 month, etc..
I'm currently using a shellscript to do this, but it would be nice to have it included in the options automysqlbackup.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Funny - Me too, but more. I'm working on adding more flexibility to the retention of backups.
I thought this project was dead and had added a bunch of stuff. Then I found it had come back to life. I'm working on merging my stuff.
# Added option to archive (rsync) the local backup files to a remote locations using the COPYDIR varaible.
# Added option to copy files into a directory based on the hostname using the
# variable HOSTNAME. This allows the script to be run from a shared storage directory
# ( SBM, NFS, NetApp) the data to be kept seperate.
# Added option to additionally backup all database schemas only using variable FULL SCHEMA.
# Added option to backup MySQL configuration file, my.cnf and remove files older then seven
# days from the BACKUPDIR directory.
# Added -master-data=2 and -single-transaction to include a comment with the master server's
# the binary log coordinates. If used the CHANGE_MASTER_TO line must be uncommented.
More coming. I'm thinking of adding LVM snapshot capability to the backups.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello
Congratulations for the great work!
The automysqlbackup solve it 99% of the problems I had with backups of my local databases.
The only thing that could not properly set up in direct scritp was the life cycle of the backup. For example:
- I like to keep up daily for 60 days
- The last 20 weekly backups
- The last 12 month, etc..
I'm currently using a shellscript to do this, but it would be nice to have it included in the options automysqlbackup.
Funny - Me too, but more. I'm working on adding more flexibility to the retention of backups.
I thought this project was dead and had added a bunch of stuff. Then I found it had come back to life. I'm working on merging my stuff.
# Added option to archive (rsync) the local backup files to a remote locations using the COPYDIR varaible.
# Added option to copy files into a directory based on the hostname using the
# variable HOSTNAME. This allows the script to be run from a shared storage directory
# ( SBM, NFS, NetApp) the data to be kept seperate.
# Added option to additionally backup all database schemas only using variable FULL SCHEMA.
# Added option to backup MySQL configuration file, my.cnf and remove files older then seven
# days from the BACKUPDIR directory.
# Added -master-data=2 and -single-transaction to include a comment with the master server's
# the binary log coordinates. If used the CHANGE_MASTER_TO line must be uncommented.
More coming. I'm thinking of adding LVM snapshot capability to the backups.