automysqlbackup-users Mailing List for AutoMySQLBackup (Page 3)
Automatic MySQL Backup
Brought to you by:
wipe_out
Menu
▾
▴
automysqlbackup-users — Users discussion and support.
You can subscribe to this list here.
| 2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
(2) |
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2005 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(9) |
Dec
|
| 2006 |
Jan
(4) |
Feb
(1) |
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2007 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
(6) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(8) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
(1) |
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
(12) |
Jul
|
Aug
(4) |
Sep
|
Oct
|
Nov
(3) |
Dec
|
| 2012 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2014 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
(1) |
Dec
|
| 2017 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2023 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Eduardo C. <eca...@gm...> - 2006-11-11 02:10:48
|
hi, great script i use it and works excellent. Now im implementing it on a mysql server that handles a very big table, more than 4Gb of records but they are changing every day so i`m not interested in backing up but the rest i need to. Is there a way to exclude one table of been dumped? thanks eduardo. |
|
From: WipeOut <wip...@us...> - 2006-05-26 13:18:51
|
How big is the database? SourceForge.net wrote: > Read and respond to this message at: > https://sourceforge.net/forum/message.php?msg_id=3751553 > By: joewho > > Hello, > > Everything was working fine, the last several days I am getting "Filesize limit > exceeded" and I don't know why? > > > Daily Backup of Database ( fillin ) > Rotating last weeks Backup... > > Filesize limit exceeded > > > Thanks, > > > ______________________________________________________________________ > You are receiving this email because you elected to monitor this forum. > To stop monitoring this forum, login to SourceForge.net and visit: > https://sourceforge.net/forum/unmonitor.php?forum_id=350021 > > |
|
From: WipeOut <wip...@us...> - 2006-02-15 14:22:47
|
Anyone who has downloaded VER 2.5 this morning please download it again.. I forgot to remove an "echo" statement that I was using during testing.. Sorry about that.. |
|
From: WipeOut <wip...@us...> - 2006-01-30 17:27:42
|
Hi all, I have had a suggestion from one of the long time users of the AutoMySQLbackup script to separate the config portion of the script and the logic portion of the script into separate files.. So for example there would be a /etc/automysqlbackup.conf config file and a /bin/automysqlbackup executable file.. The next thing is having a Makefile that will install the files to prescribed locations.. This would allow the AutoMySQLbackup "system" to be packaged.. I would be interested to hear the thoughts on this from those of you who use the script.. How would this change affect the way you use the script? Where would the best file system locations be for the files? (eg. /etc/automysqlbackup.conf or /etc/automysqlbackup/config ) Is this something you would like to see and prefer to the way it is currently? Anything else? |
|
From: Sam S. <sn...@la...> - 2006-01-25 15:54:57
|
WipeOut said: > Sam Snow wrote: > >>I just submitted this as a formal feature request. See >>https://sourceforge.net/tracker/index.php?func=detail&aid=1359027&group_id=101066&atid=628967 >> >>Sam >> >> >> >> >> > Just thinking about it a little more this is probably not that hard to > do.. > If I get a chance to look at it in the next few days I will see if I can > implement it.. > > Later.. > > Thank you for the new feature. I've upgraded the school using this to version 2.4 and it is working very well. Many thanks! Sam |
|
From: WipeOut <wip...@us...> - 2006-01-09 17:45:29
|
Bob in Florida wrote: > My hosting service says that all cron jobs have to be cgi scripts. Can > I just put my automysqlbackup in the cgi-bin folder or do I have to put > it there and change the suffix from .sh to .cgi. I am a new subscriber > to the list and Sourcforge is down right now so I cannot search the > archives for this topic. My apologies if this has been discussed before. > > I have never tried to run it that way so I am not sure if it will work... I guess that as long as the required utilities can be executed and the directories accessed for the CGI execution it should work but your ISP may not allow it to call external utilities or write to the backup directory.. Sorry I can't be more helpful.. |
|
From: Bob in F. <bo...@th...> - 2006-01-09 15:32:47
|
My hosting service says that all cron jobs have to be cgi scripts. Can I just put my automysqlbackup in the cgi-bin folder or do I have to put it there and change the suffix from .sh to .cgi. I am a new subscriber to the list and Sourcforge is down right now so I cannot search the archives for this topic. My apologies if this has been discussed before. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.371 / Virus Database: 267.14.15/223 - Release Date: 1/6/2006 |
|
From: WipeOut <wip...@us...> - 2005-11-17 16:19:43
|
Sam Snow wrote: >I just submitted this as a formal feature request. See >https://sourceforge.net/tracker/index.php?func=detail&aid=1359027&group_id=101066&atid=628967 > >Sam > > > > > Just thinking about it a little more this is probably not that hard to do.. If I get a chance to look at it in the next few days I will see if I can implement it.. Later.. |
|
From: Sam S. <sn...@la...> - 2005-11-17 15:27:36
|
I just submitted this as a formal feature request. See https://sourceforge.net/tracker/index.php?func=detail&aid=1359027&group_id=101066&atid=628967 Sam |
|
From: Sam S. <sn...@la...> - 2005-11-11 22:08:55
|
While the emailed log files are great, I would love to see a "quiet" setting for the email. In this case it would only email if there was an error. Otherwise there would be no output at all (so as to not trigger an email from cron when the program is called). I currently comment out a line or two so that no email at all is sent. thanks for putting together and sharing your script, Sam |
|
From: WipeOut <wip...@us...> - 2005-11-08 08:37:04
|
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 > > |
|
From: Dan H. <dan...@re...> - 2005-11-08 03:57:23
|
Right you are Thanks Dan > -----Original Message----- > From: aut...@li... > [mailto:aut...@li...] On Behalf Of > Rob Rosenfeld > Sent: Tuesday, 8 November 2005 4:40 p.m. > To: aut...@li... > Subject: Re: [Automysqlbackup-users] Feature request > > Dan Horne wrote: > > >Any chance of being able to specify that all DBs get backed up? Every > time I > >create a database, I have to remember to add it to the config (and > >sometimes I forget for a couple of days). I'd like to be able to say > "backup > >all dbs" > > > > > > > > > I think the config setting below does that. You can use the exclude > list with it. > > DBNAMES="all" > > > ------------------------------------------------------- > 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 |
|
From: Rob R. <ro...@ro...> - 2005-11-08 03:40:50
|
Dan Horne wrote: >Any chance of being able to specify that all DBs get backed up? Every time I >create a database, I have to remember to add it to the config (and >sometimes I forget for a couple of days). I'd like to be able to say "backup >all dbs" > > > I think the config setting below does that. You can use the exclude list with it. DBNAMES="all" |
|
From: Dan H. <dan...@re...> - 2005-11-08 03:35:45
|
Any chance of being able to specify that all DBs get backed up? Every time I create a database, I have to remember to add it to the config (and sometimes I forget for a couple of days). I'd like to be able to say "backup all dbs" Dan |
|
From: Rob R. <ro...@ro...> - 2005-11-08 03:05:06
|
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! > |
|
From: WipeOut <wip...@us...> - 2005-11-07 18:36:35
|
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.. |
|
From: WipeOut <wip...@us...> - 2004-11-04 07:54:42
|
Rob Rosenfeld wrote: > Thanks for the useful script. > There is a bug in automysqlbackup v2.0 where daily backups aren't > rotated if you do not use gzip for compression. > > Compare the rotation call in weekly vs. that in daily. Daily doesn't > look for a wildcard extension, but .gz instead > > eval rm -fv "$BACKUPDIR/weekly/$DB/week.$REMW.*" > eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.gz" > > I believe the daily rotation eval statement ( line 453 for me ) should > read > eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*" > Well spotted Rob.. I guess that one slipped by.. Thanks for taking the time to find and fix the problem.. I have updated the script and will upload ver 2.1 to SF now.. Later.. |
|
From: Rob R. <ro...@ro...> - 2004-11-03 23:56:23
|
Thanks for the useful script.
There is a bug in automysqlbackup v2.0 where daily backups aren't
rotated if you do not use gzip for compression.
Compare the rotation call in weekly vs. that in daily. Daily doesn't
look for a wildcard extension, but .gz instead
eval rm -fv "$BACKUPDIR/weekly/$DB/week.$REMW.*"
eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.gz"
I believe the daily rotation eval statement ( line 453 for me ) should read
eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*"
|
|
From: Friedrich L. <fl...@fl...> - 2004-07-15 17:00:01
|
Friedrich Lobenstock wrote on 15.07.2004 18:56 MET: > WipeOut wrote on 15.07.2004 18:42 MET: >> >> I don't have a problem creating one script for both DB's, >> unfortunately I don't have a postgress box to test it with and i don't >> know postgres all that well but I am sure it could get there in the end.. > > > The differences of MySQL and PostgreSQL are basically > * how to get the list of databases > * how to set the password > * pg_dump has some only some different parameters > * pg_dump does not support export of more than one database at a > time therefore for SEPDIR=no extra code would need to be added Forgot to add just have a look at the patch. PS: For postgres testing you now know who to talk to ;-) -- MfG / Regards Friedrich Lobenstock ____________________________________________________________________ Friedrich Lobenstock Linux Services Lobenstock URL: http://www.lsl.at/ Email: fl...@fl... ____________________________________________________________________ |
|
From: Friedrich L. <fl...@fl...> - 2004-07-15 16:56:10
|
WipeOut wrote on 15.07.2004 18:42 MET: > Friedrich Lobenstock wrote: > >> Hi! >> >> At ftp://ftp.fl.priv.at/pub/autopostgresbackup/ you can find: >> - a patch to convert automysqlbackup to autopostgresbackup >> - the already patched script now called autopostgresbackup.sh >> >> Notes: >> - SEPDIR=no is currently not supported! >> - patch also available via >> http://sourceforge.net/tracker/?group_id=101066&atid=628966 >> >> PS: How about supporting both databases with just one script? >> > Thats cool.. :) > > I don't have a problem creating one script for both DB's, unfortunately > I don't have a postgress box to test it with and i don't know postgres > all that well but I am sure it could get there in the end.. The differences of MySQL and PostgreSQL are basically * how to get the list of databases * how to set the password * pg_dump has some only some different parameters * pg_dump does not support export of more than one database at a time therefore for SEPDIR=no extra code would need to be added -- MfG / Regards Friedrich Lobenstock ____________________________________________________________________ Friedrich Lobenstock Linux Services Lobenstock URL: http://www.lsl.at/ Email: fl...@fl... ____________________________________________________________________ |
|
From: WipeOut <wip...@us...> - 2004-07-15 16:42:51
|
Friedrich Lobenstock wrote: > Hi! > > At ftp://ftp.fl.priv.at/pub/autopostgresbackup/ you can find: > - a patch to convert automysqlbackup to autopostgresbackup > - the already patched script now called autopostgresbackup.sh > > Notes: > - SEPDIR=no is currently not supported! > - patch also available via > http://sourceforge.net/tracker/?group_id=101066&atid=628966 > > PS: How about supporting both databases with just one script? > Thats cool.. :) I don't have a problem creating one script for both DB's, unfortunately I don't have a postgress box to test it with and i don't know postgres all that well but I am sure it could get there in the end.. |
|
From: Friedrich L. <fl...@fl...> - 2004-07-15 16:26:29
|
Hi! At ftp://ftp.fl.priv.at/pub/autopostgresbackup/ you can find: - a patch to convert automysqlbackup to autopostgresbackup - the already patched script now called autopostgresbackup.sh Notes: - SEPDIR=no is currently not supported! - patch also available via http://sourceforge.net/tracker/?group_id=101066&atid=628966 PS: How about supporting both databases with just one script? -- MfG / Regards Friedrich Lobenstock ____________________________________________________________________ Friedrich Lobenstock Linux Services Lobenstock URL: http://www.lsl.at/ Email: fl...@fl... ____________________________________________________________________ |
