Hi,
I have been trying to find any documentation on how to setup hourly backups (which I was able to setup easily) but with differential backups and rotation.
The rotation is ignored and I end with too many daily files.
(I just posted this a minute ago but it didn't appear - I don't know if moderation is in effect but there was no msg to say so so I'm posting this again):
Hi darkpollo,
I'm a user of automysql and I've got an issue similar to yours so I thought I'd respond.
I'm sure you found that to setup hourly backups you put the script / symbolic link / etc into /etc/cron/hourly (debian) or create a launchAgent script on MacOSX. And something similar for other *nix distros.
Deltas are not supported in this tool. Automysqlbackup is a simple shell script that when run dumps out the chosen databases in daily, weekly and monthly directories under a backup root. And cleans past backups. Deltas would be nice but would make it more complex that it is intended to be (AFAIU). Perhaps a git bare repo could be created and let it manage it all. Another advantage of a git repo would be that you could easily backup the backup by pushing to a remote. This would then seem to avert the need of daily / weekly / monthly backups and a new tool should be created.
My issue, which possibly relates to your comment "The rotation is ignored and I end with too many daily files." is that when backing up hourly you get 24 dumps a day. That's cool. But then you get 24 for every week and every month. The problem is is that the script is run and separate dumps are made on the scheduled weekly or monthly day. So when its run 24 times it happens 24 times in that same chosen day. I need to stop this and will make a change so that the weekly and montly dump is only done the first time. If I can, I will push the change I will make (I haven't looked to see what abilities I have to contribute to this project and what version control system is in use).
I hope that helped answer your questions.
Cheers,
Brooke
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hey!
I wrote this post in 2014 and I gave up on using this after a couple of months because of this "bug" and the lack of support.
Thank you anyway for answering this!
Maybe I could give it a try again in the future.
Cheers
Ángel
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I asked a maintainer if they'd truly open source the project and put it on somewhere such as github where it can be worked on by others and forked if desired. I haven't heard back from them. It is worth persueing unless there is something just as good and open source out there.
Did you find any alternatives?
On 30/03/2016 02:00, darkpollo wrote:
Hey!
I wrote this post in 2014 and I gave up on using this after a couple of
months because of this "bug" and the lack of support.
Thank you anyway for answering this!
Maybe I could give it a try again in the future.
Status: open Group: v1.0 (example) Created: Fri Feb 28, 2014 01:36 PM UTC by darkpollo Last Updated: Sun Mar 13, 2016 10:58 AM UTC Owner: nobody
Hi,
I have been trying to find any documentation on how to setup hourly
backups (which I was able to setup easily) but with differential backups
and rotation.
The rotation is ignored and I end with too many daily files.
(I just posted this a minute ago but it didn't appear - I don't know if moderation is in effect but there was no msg to say so so I'm posting this again):
Hi darkpollo,
I'm a user of automysql and I've got an issue similar to yours so I thought I'd respond.
I'm sure you found that to setup hourly backups you put the script / symbolic link / etc into
/etc/cron/hourly(debian) or create a launchAgent script on MacOSX. And something similar for other *nix distros.Deltas are not supported in this tool. Automysqlbackup is a simple shell script that when run dumps out the chosen databases in daily, weekly and monthly directories under a backup root. And cleans past backups. Deltas would be nice but would make it more complex that it is intended to be (AFAIU). Perhaps a git bare repo could be created and let it manage it all. Another advantage of a git repo would be that you could easily backup the backup by pushing to a remote. This would then seem to avert the need of daily / weekly / monthly backups and a new tool should be created.
My issue, which possibly relates to your comment "The rotation is ignored and I end with too many daily files." is that when backing up hourly you get 24 dumps a day. That's cool. But then you get 24 for every week and every month. The problem is is that the script is run and separate dumps are made on the scheduled weekly or monthly day. So when its run 24 times it happens 24 times in that same chosen day. I need to stop this and will make a change so that the weekly and montly dump is only done the first time. If I can, I will push the change I will make (I haven't looked to see what abilities I have to contribute to this project and what version control system is in use).
I hope that helped answer your questions.
Cheers,
Brooke
Hey!
I wrote this post in 2014 and I gave up on using this after a couple of months because of this "bug" and the lack of support.
Thank you anyway for answering this!
Maybe I could give it a try again in the future.
Cheers
Ángel
I asked a maintainer if they'd truly open source the project and put it on somewhere such as github where it can be worked on by others and forked if desired. I haven't heard back from them. It is worth persueing unless there is something just as good and open source out there.
Did you find any alternatives?
On 30/03/2016 02:00, darkpollo wrote:
Related
Support Requests: #24
Kind of. Now I am using hourly backups from my server and for 24hours I use dumps and upload to S3.
But before this I was using Percona for the incrementa backups. I have some links from when I was looking information about it, google will help you here too.
This post is one that help me.
https://deviantony.wordpress.com/2013/09/24/percona-xtrabackup-scripts/#comment-10
And the updated one:
https://deviantony.wordpress.com/2014/05/18/percona-xtrabackup-scripts-part-2/
And yeah, a github repo will be best for sure.
Thanks!