Re: [Automysqlbackup-users] Ver 2.3 release

[WipeOut <wip...@us...>]

Hi,

I haven't actually bumped into that limit, the largest single database I 
have used the script on was about 300MB..
My suggestion would be to look at the system variables and see if there 
are any timeouts or maximums that are limiting you.. Alternatively you 
may get some guidance from someone of one of the MySQL forums.. Sorry I 
can't be of more help..

For your second question.. The reason for the 5 week rotation is simply 
because there can be a maximum of 5 weeks in a month so it is simply to 
maintain a GFS backup structure.. I guess it could be user configurable 
but trying to do it per database would be quite difficult and would make 
the script a lot more complicated..
There is a patch that has been submitted for monthly rotation on the 
sourceforge.net AutoMySQLBackup project page for monthly rotation but I 
haven't had a chance to go through it yet..
Alternatively what you could do is setup a cron job to run to delete the 
backups you don't want on a weekly or monthly basis using the "find" 
command, for example you could delete files older than x days..

Rob Rosenfeld wrote:

> Hey still happily using your script and this email reminded me of some 
> questions I've had.  Hope you don't mind answering them.
>
> 1)  There seems to be a limit of 900MB in backup space.  Where is that 
> limit set?
> 2)  Is there a way to control the number of weekly and monthly backups 
> kept?  Idealy, I'd like to set this per database.
>
> Thanks for the script.
>
> Rob
>
> WipeOut wrote:
>
>> Hi,
>>
>> For anyone interested version 2.3 is now available..
>> New features are..
>> 1) Detecting errors and notifying admin depending on selected 
>> notification options..
>> 2) Option to compress MySQL traffic between backup server and MySQL 
>> server..
>>
>> Let me know if there are any problems with it that slipped through my 
>> testing..
>>
>>
>>
>>
>> -------------------------------------------------------
>> SF.Net email is sponsored by:
>> Tame your development challenges with Apache's Geronimo App Server. 
>> Download
>> it for free - -and be entered to win a 42" plasma tv or your very own
>> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
>> _______________________________________________
>> Automysqlbackup-users mailing list
>> Aut...@li...
>> https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users
>>
>> !DSPAM:436f9f00174918597412598!
>>
>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by:
> Tame your development challenges with Apache's Geronimo App Server. 
> Download
> it for free - -and be entered to win a 42" plasma tv or your very own
> Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
> _______________________________________________
> Automysqlbackup-users mailing list
> Aut...@li...
> https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users
>
>