Screenshot instructions:
Windows
Mac
Red Hat Linux
Ubuntu
Click URL instructions:
Right-click on ad, choose "Copy Link", then paste here →
(This may not be possible with some types of ads)
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
|
|
From: Ward Loockx <ward@lo...> - 2011-06-02 17:25:50
|
Hello, Thanks for the reply. I have control over the mysql settings. I'll also take a look at mysqlhotcopy. 2011/6/2 Wipe_Out <wipe_out@...> > Hi, > > It could be an issue with the server running out of memory while dumping > that large table.. The --opt switch is used which should disable memory > buffering when its dumping the database but perhaps its something else.. It > could also be that the table is being locked for a long time which is > causing a problem for your website.. > > Are you able to change the MySQL server settings? eg buffers etc.. > > An alternative would be to not use the script to backup that database and > instead use the mysqlhotcopy command which may work better for a larger > database thats always active.. > > > > Does seem strange because > > On 2 June 2011 08:44, Ward Loockx <ward@...> wrote: > >> Hello, >> >> I currently use automysqlbackup to backup 10databases. There is one big >> database that contains a table with +- 780.000records. When mysqlbackup >> executes it fails (on that table) and brings my websites down (maybe the >> load is so high that apache processes can't answer in time). Looks like >> there are a lot of query's executed at the moment of backup and maybe the >> query's are locking each other. >> >> I also get the following by email: >> >> mysqldump: Error 2013: Lost connection to MySQL server during query when >> dumping table `video` at row: 745740 >> >> I think this are 2seperate problems: >> >> - Mysql backup script failing >> - Website's are down (because the use of too many resources?) >> >> >> Do you guys have any ideas how to fix this? Can you let the script run in >> low priority mode, so that it doesn't eat the resources and does not lock >> any tables ? >> >> Thanks! >> Ward >> >> >> >> >> ------------------------------------------------------------------------------ >> Simplify data backup and recovery for your virtual environment with >> vRanger. >> Installation's a snap, and flexible recovery options mean your data is >> safe, >> secure and there when you need it. Data protection magic? >> Nope - It's vRanger. Get your free trial download today. >> http://p.sf.net/sfu/quest-sfdev2dev >> _______________________________________________ >> Automysqlbackup-users mailing list >> Automysqlbackup-users@... >> https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users >> >> > > > ------------------------------------------------------------------------------ > Simplify data backup and recovery for your virtual environment with > vRanger. > Installation's a snap, and flexible recovery options mean your data is > safe, > secure and there when you need it. Discover what all the cheering's about. > Get your free trial download today. > http://p.sf.net/sfu/quest-dev2dev2 > _______________________________________________ > Automysqlbackup-users mailing list > Automysqlbackup-users@... > https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users > > |
|
From: Wipe_Out <wipe_out@us...> - 2011-06-02 17:07:50
|
Hi, It could be an issue with the server running out of memory while dumping that large table.. The --opt switch is used which should disable memory buffering when its dumping the database but perhaps its something else.. It could also be that the table is being locked for a long time which is causing a problem for your website.. Are you able to change the MySQL server settings? eg buffers etc.. An alternative would be to not use the script to backup that database and instead use the mysqlhotcopy command which may work better for a larger database thats always active.. Does seem strange because On 2 June 2011 08:44, Ward Loockx <ward@...> wrote: > Hello, > > I currently use automysqlbackup to backup 10databases. There is one big > database that contains a table with +- 780.000records. When mysqlbackup > executes it fails (on that table) and brings my websites down (maybe the > load is so high that apache processes can't answer in time). Looks like > there are a lot of query's executed at the moment of backup and maybe the > query's are locking each other. > > I also get the following by email: > > mysqldump: Error 2013: Lost connection to MySQL server during query when > dumping table `video` at row: 745740 > > I think this are 2seperate problems: > > - Mysql backup script failing > - Website's are down (because the use of too many resources?) > > > Do you guys have any ideas how to fix this? Can you let the script run in > low priority mode, so that it doesn't eat the resources and does not lock > any tables ? > > Thanks! > Ward > > > > > ------------------------------------------------------------------------------ > Simplify data backup and recovery for your virtual environment with > vRanger. > Installation's a snap, and flexible recovery options mean your data is > safe, > secure and there when you need it. Data protection magic? > Nope - It's vRanger. Get your free trial download today. > http://p.sf.net/sfu/quest-sfdev2dev > _______________________________________________ > Automysqlbackup-users mailing list > Automysqlbackup-users@... > https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users > > |
|
From: Ward Loockx <ward@lo...> - 2011-06-02 07:44:47
|
Hello, I currently use automysqlbackup to backup 10databases. There is one big database that contains a table with +- 780.000records. When mysqlbackup executes it fails (on that table) and brings my websites down (maybe the load is so high that apache processes can't answer in time). Looks like there are a lot of query's executed at the moment of backup and maybe the query's are locking each other. I also get the following by email: mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table `video` at row: 745740 I think this are 2seperate problems: - Mysql backup script failing - Website's are down (because the use of too many resources?) Do you guys have any ideas how to fix this? Can you let the script run in low priority mode, so that it doesn't eat the resources and does not lock any tables ? Thanks! Ward |
|
From: Stewart Matheson <stew@rt...> - 2011-03-24 07:38:46
|
Hello when I try and run the script with MAILCONTENT="files" I get the following error. stewart@...:~/scripts$ ./backup.sh Can't stat stew@...: No such file or directory stew@...: unable to attach file. Can someone explain why this is happening? Thanks in advance for any help. |
|
From: Kyle Hall <kyle.m.hall@gm...> - 2011-03-10 13:53:22
|
Hello All,
I just set up automysqlbackup for the first time. Kudos to the
author for writing such an excellent tool! I do have an issue however.
When I run the script to test it, I get this message:
###### WARNING ######
Errors reported during AutoMySQLBackup execution.. Backup failed
Error log below..
/usr/local/bin/automysqlbackup: line 679: [: 4: unary operator expected
Line 679 of the script looks like this:
if [ ${DNOW} = ${DOWEEKLY} ]; then
I see nothing wrong with the code, but I'm no shell scripting expert.
Is this something that needs to be fixed, or can I just ignore this?
Thanks,
Kyle
http://www.kylehall.info
Mill Run Technology Solutions ( http://millruntech.com )
Crawford County Federated Library System ( http://www.ccfls.org )
Meadville Public Library ( http://www.meadvillelibrary.org )
|
|
From: Tahseen raza <kashan.glt1@gm...> - 2011-01-06 09:52:52
|
i want to use open bravo 4 my retail shop but when i open it it shows me that data base cant be detected,, what should i do plz let me know procedure briefly. regard tahseen |
|
From: Russell Jones <rjones@eg...> - 2009-07-22 13:55:44
|
I am already using version 2.5. I applied the change to line 539. Hopefully this will fix it. Thanks! WipeOut wrote: > Adrian Simmons wrote: > >> On 22 Jul 2009, at 10:46, WipeOut wrote: >> >>> I am currently testing an updated version with a patch applied to fix >>> the weekly rotation but and also updates the way the daily archive is >>> maintained.. If all goes well I will post it in the next week or two.. >>> >> Yeah, I just found the issue for this, if anyone needs this now, there >> is a patch: >> http://sourceforge.net/tracker/?func=detail&aid=1575311&group_id=101066&atid=628964 >> >> Ignore my last email about the change to line 539, this patch does it >> properly. >> >> Adrian >> > > That is another way to resolve it as well.. :) > > ------------------------------------------------------------------------------ > _______________________________________________ > Automysqlbackup-users mailing list > Automysqlbackup-users@... > https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users > |
|
From: WipeOut <wipe_out@us...> - 2009-07-22 10:24:16
|
Adrian Simmons wrote: > On 22 Jul 2009, at 10:46, WipeOut wrote: >> I am currently testing an updated version with a patch applied to fix >> the weekly rotation but and also updates the way the daily archive is >> maintained.. If all goes well I will post it in the next week or two.. > > Yeah, I just found the issue for this, if anyone needs this now, there > is a patch: > http://sourceforge.net/tracker/?func=detail&aid=1575311&group_id=101066&atid=628964 > > Ignore my last email about the change to line 539, this patch does it > properly. > > Adrian That is another way to resolve it as well.. :) |
|
From: WipeOut <wipe_out@us...> - 2009-07-22 10:22:50
|
Adrian Simmons wrote:
> On 22 Jul 2009, at 01:43, Russell Jones wrote:
>> Am I not understanding something correctly, or is there an error I am
>> encountering?
> You do have 2.5?
> # VER 2.4 - (2006-01-23)
> # Fixed bug where weekly backups were not being rotated. (Fix by
> wolf02)
>
> I have 2.5 and have the same problem, but it's worth checking I guess.
>
> There are some differences between the routines used for rotating
> weekly backup depending on whether you use a separate directory for
> each db or whether all db's are in one. I use the separate directory
> setting, I think there is a bug with that...
>
> At line 539:
>
> eval rm -fv "$BACKUPDIR/weekly/$DB_week.$REMW.*"
>
> ought to be:
>
> eval rm -fv "$BACKUPDIR/weekly/${DB}_week.$REMW.*"
>
> Because in the former the variable name will be $DB_week. which
> doesn't exist, rather than $DB which is the db name being used. I'll
> give this change a shot. But I'm a shell scripting noob so use it at
> your own risk!
>
> Adrian
The updated version will use "find" and delete all files older than a
specified number of days.. Should simplify the existing logic and clean
up everything.. :)
|
|
From: Adrian Simmons <adrian@pe...> - 2009-07-22 10:18:52
|
On 22 Jul 2009, at 10:46, WipeOut wrote: > I am currently testing an updated version with a patch applied to fix > the weekly rotation but and also updates the way the daily archive is > maintained.. If all goes well I will post it in the next week or two.. Yeah, I just found the issue for this, if anyone needs this now, there is a patch: http://sourceforge.net/tracker/?func=detail&aid=1575311&group_id=101066&atid=628964 Ignore my last email about the change to line 539, this patch does it properly. Adrian -- Phone: +44 1382 541 586 or +44 131 208 0840 e-mail <mailto:adrian@...> AOL/Yahoo/Skype/Gizmo ID: perlucida Web Site <http://perlucida.com>; |
|
From: WipeOut <wipe_out@us...> - 2009-07-22 10:07:54
|
Adrian Simmons wrote: > On 22 Jul 2009, at 01:43, Russell Jones wrote: > >> Am I not understanding something correctly, or is there an error I am >> encountering? > Looks like I have the same problem, also for monthly, there's backups > in both going back to 2007 on some of my sites. > My first thought was a permissions problem, but they seem to be > identical for both daily, weekly and monthly. > > Off to look through the script see, if there's anything obvious. > > Adrian I am currently testing an updated version with a patch applied to fix the weekly rotation but and also updates the way the daily archive is maintained.. If all goes well I will post it in the next week or two.. |
|
From: Adrian Simmons <adrian@pe...> - 2009-07-22 10:06:14
|
On 22 Jul 2009, at 01:43, Russell Jones wrote:
> Am I not understanding something correctly, or is there an error I am
> encountering?
You do have 2.5?
# VER 2.4 - (2006-01-23)
# Fixed bug where weekly backups were not being rotated. (Fix by
wolf02)
I have 2.5 and have the same problem, but it's worth checking I guess.
There are some differences between the routines used for rotating
weekly backup depending on whether you use a separate directory for
each db or whether all db's are in one. I use the separate directory
setting, I think there is a bug with that...
At line 539:
eval rm -fv "$BACKUPDIR/weekly/$DB_week.$REMW.*"
ought to be:
eval rm -fv "$BACKUPDIR/weekly/${DB}_week.$REMW.*"
Because in the former the variable name will be $DB_week. which
doesn't exist, rather than $DB which is the db name being used. I'll
give this change a shot. But I'm a shell scripting noob so use it at
your own risk!
Adrian
--
Phone: +44 1382 541 586 or +44 131 208 0840
e-mail <mailto:adrian@...>
AOL/Yahoo/Skype/Gizmo ID: perlucida
Web Site <http://perlucida.com>;
|
|
From: Adrian Simmons <adrian@pe...> - 2009-07-22 09:36:58
|
On 22 Jul 2009, at 01:43, Russell Jones wrote: > Am I not understanding something correctly, or is there an error I am > encountering? Looks like I have the same problem, also for monthly, there's backups in both going back to 2007 on some of my sites. My first thought was a permissions problem, but they seem to be identical for both daily, weekly and monthly. Off to look through the script see, if there's anything obvious. Adrian -- Phone: +44 1382 541 586 or +44 131 208 0840 e-mail <mailto:adrian@...> AOL/Yahoo/Skype/Gizmo ID: perlucida Web Site <http://perlucida.com>; |
|
From: Russell Jones <rjones@eg...> - 2009-07-22 01:03:35
|
I have a separate script that runs to zip up my weekly backups and move them to a separate place. However I noticed that this file seemed to be getting a little large. Upon inpsection I noticed that the weekly folder held several months worth of backups. Here is one database's folder within the weekly folder: -r-------- 1 root root 104173 May 2 04:02 mysql_week.18.2009-05-02_04h02m.sql.gz -r-------- 1 root root 104169 May 9 04:02 mysql_week.19.2009-05-09_04h02m.sql.gz -r-------- 1 root root 104169 May 16 04:02 mysql_week.20.2009-05-16_04h02m.sql.gz -r-------- 1 root root 104272 May 23 04:02 mysql_week.21.2009-05-23_04h02m.sql.gz -r-------- 1 root root 104272 May 30 04:02 mysql_week.22.2009-05-30_04h02m.sql.gz -r-------- 1 root root 104271 Jun 6 04:02 mysql_week.23.2009-06-06_04h02m.sql.gz -r-------- 1 root root 104272 Jun 13 04:02 mysql_week.24.2009-06-13_04h02m.sql.gz -r-------- 1 root root 104272 Jun 20 04:02 mysql_week.25.2009-06-20_04h02m.sql.gz -r-------- 1 root root 104272 Jun 27 04:02 mysql_week.26.2009-06-27_04h02m.sql.gz -r-------- 1 root root 104272 Jul 4 04:02 mysql_week.27.2009-07-04_04h02m.sql.gz -r-------- 1 root root 104271 Jul 11 04:02 mysql_week.28.2009-07-11_04h02m.sql.gz -r-------- 1 root root 104274 Jul 18 04:02 mysql_week.29.2009-07-18_04h02m.sql.gz I was under the impression that the weekly folder would hold only 5 weeks worth of backups. Per under the Backup Rotation section: # Weekly Backups are rotated on a 5 week cycle.. Am I not understanding something correctly, or is there an error I am encountering? Thanks! |
|
From: Javier Barroso <Javier.Barroso@is...> - 2007-11-09 10:31:53
|
Hello, I've just post a patch to automysqlbackup.sh-2.5 that include a new HARDLINK option. See http://sourceforge.net/tracker/index.php?func=detail&aid=1828831&group_id=101066&atid=628966 for details Default is HARDLINK=no for compatibilities issues. Older backups (backup files created before this patch is applied) are not tracking automatically, if you want I can attach a script that make the hack for it. Thank you -- Javier Barroso Tristán Administrador de Redes y Sistemas DIRECCIÓN DE TECNOLOGÍA:OPERACIONES Y SOPORTE javier.barroso@... -------------------------------------------- ISOTROL Edificio BLUENET. Avda. Isaac Newton nº 3, 4ª planta. Parque Tecnológico Cartuja '93, 41092 Sevilla. Teléfono: 955 036 800 - Fax: 955 036 849 http://www.isotrol.com |
|
From: BenRifkah Bergsten-Buret <benb@sp...> - 2007-08-15 18:24:13
|
WipeOut wrote: > BenRifkah Bergsten-Buret wrote: >> Greetings, >> >> I've inherited a legacy system that is using automysqlbackup2.2. The >> previous developer has told me that they made some minor changes to >> the v2.2 script, but cannot remember what they were. If anyone can >> send me a copy of v2.2 I'd appreciate it (the earliest version on the >> source forge archive is 2.3). >> >> I'm going to analyze our version against the stock v2.2 to see what >> kinds of differences there are and then upgrade to v2.5. It doesn't >> look like there should be any problems with this process but if >> anyone knows of problems I might face I'd like to hear about them. >> >> Thanks, >> >> -- Ben >> > > Hi Ben, > > Attached is a copy of ver 2.2.. Hope it helps.. Thanks, -- Ben |
|
From: WipeOut <wipe_out@us...> - 2007-08-15 14:29:35
|
BenRifkah Bergsten-Buret wrote: > Greetings, > > I've inherited a legacy system that is using automysqlbackup2.2. The > previous developer has told me that they made some minor changes to the > v2.2 script, but cannot remember what they were. If anyone can send me > a copy of v2.2 I'd appreciate it (the earliest version on the source > forge archive is 2.3). > > I'm going to analyze our version against the stock v2.2 to see what > kinds of differences there are and then upgrade to v2.5. It doesn't > look like there should be any problems with this process but if anyone > knows of problems I might face I'd like to hear about them. > > Thanks, > > -- Ben > Hi Ben, Attached is a copy of ver 2.2.. Hope it helps.. |
|
From: adam fisher <afisher@ci...> - 2007-08-15 04:33:14
|
----- BenRifkah Bergsten-Buret <benb@...> wrote: > Greetings, > > I've inherited a legacy system that is using automysqlbackup2.2. The > > previous developer has told me that they made some minor changes to > the > v2.2 script, but cannot remember what they were. If anyone can send > me > a copy of v2.2 I'd appreciate it (the earliest version on the source > forge archive is 2.3). > > I'm going to analyze our version against the stock v2.2 to see what > kinds of differences there are and then upgrade to v2.5. It doesn't > look like there should be any problems with this process but if anyone > > knows of problems I might face I'd like to hear about them. > > Thanks, > > -- Ben > Ben, I am not sure about upgrading or what not, but when we add the patches that were available in the bug report for 2.5, especially the one where you can do per table backups, it broke the script. We had to fix how it did the rotation(the rotation patch didn't seem to do the trick). It seemed that it would first run the back up but then delete it. I have long since forgotten the changes but if you want a copy of ours just let me know. We could never get the ignore table patch to actually ignore a table either if somebody has any ideas on that. Adam Fisher IT Coordinator CirclePix 801-318-4585 ext.6603 1-877-390-6630 ext.6603 |
|
From: BenRifkah Bergsten-Buret <benb@sp...> - 2007-08-15 00:29:29
|
Greetings, I've inherited a legacy system that is using automysqlbackup2.2. The previous developer has told me that they made some minor changes to the v2.2 script, but cannot remember what they were. If anyone can send me a copy of v2.2 I'd appreciate it (the earliest version on the source forge archive is 2.3). I'm going to analyze our version against the stock v2.2 to see what kinds of differences there are and then upgrade to v2.5. It doesn't look like there should be any problems with this process but if anyone knows of problems I might face I'd like to hear about them. Thanks, -- Ben |
|
From: michelle_day_99 <michelle_day_99@ya...> - 2007-08-03 22:17:35
|
NOT ABLE TO BACKUP THE TABLES Private: (?)=20
No =20
Hi All,
I am new to Linx and MYSQL I have managed to get the Auto backup =
working
but when I unzip it I get the below dump and when I restore I get =
the
Database but no Tables what am I doing wrong
-- MySQL dump 10.11
--
-- Host: localhost Database: World
-- ------------------------------------------------------
-- Server version 5.0.32-Debian_7etch1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=3D@@CHARACTER_SET_CLIENT =
*/;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=3D@@CHARACTER_SET_RESULTS =
*/;
/*!40101 SET @OLD_COLLATION_CONNECTION=3D@@COLLATION_CONNECTION =
*/;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=3D@@TIME_ZONE */;
/*!40103 SET TIME_ZONE=3D'+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=3D@@UNIQUE_CHECKS, =
UNIQUE_CHECKS=3D0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=3D@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=3D0 */;
/*!40101 SET @OLD_SQL_MODE=3D@@SQL_MODE, =
SQL_MODE=3D'NO_AUTO_VALUE_ON_ZERO'
*/;
/*!40111 SET @OLD_SQL_NOTES=3D@@SQL_NOTES, SQL_NOTES=3D0 */;
Can you also tell me how I get it to keep a log file it has the =
option to
email it but I don't have email on the test server and wanted to =
get a log
file in my directory to look at.
Regards,
Michelle Day=20
|
|
From: Robert Oschwald <roos@sy...> - 2007-08-03 10:33:40
|
Hi all, Is it possible to use automysqlbackup to backup InnoDB databases? Robert |
|
From: Adam Fisher <afisher@ci...> - 2007-07-10 16:23:49
|
When I added the per table patch to the script. The rotation for daily,
weekly, and monthly backups has not worked. In the weekly directory I
have a folder for every day of the week that gets created but only the 7
day actually contains any data.
drwxr-xr-x 2 nobody wheel 4096 Jul 3 01:07
circlepix_pertable.week.27.2007-07-03_01h00m
drwxr-xr-x 2 nobody wheel 4096 Jul 4 01:07
circlepix_pertable.week.27.2007-07-04_01h00m
drwxr-xr-x 2 nobody wheel 4096 Jul 5 01:07
circlepix_pertable.week.27.2007-07-05_01h00m
drwxr-xr-x 2 nobody wheel 4096 Jul 6 01:07
circlepix_pertable.week.27.2007-07-06_01h00m
drwxr-xr-x 2 nobody wheel 4096 Jul 7 01:07
circlepix_pertable.week.27.2007-07-07_01h00m
drwxr-xr-x 2 nobody wheel 12288 Jul 8 01:22
circlepix_pertable.week.27.2007-07-08_01h00m
drwxr-xr-x 2 nobody wheel 4096 Jul 9 01:08
circlepix_pertable.week.28.2007-07-09_01h00m
drwxr-xr-x 2 nobody wheel 4096 Jul 10 01:08
circlepix_pertable.week.28.2007-07-10_01h00m
Here is my script.
I have added the per table patch and the weekly rotation patch but to no
avail.
Please let me know what I need to change.
thanks
Adam
PATH=/usr/local/bin:/usr/bin:/bin:/usr/local/mysql/bin
DATE=`date +%Y-%m-%d_%Hh%Mm` # Datestamp e.g 2002-09-21
DOW=`date +%A` # Day of the week e.g. Monday
DNOW=`date +%u` # Day number of the week 1 to 7
where 1 represents Monday
DOM=`date +%d` # Date of the Month e.g. 27
M=`date +%B` # Month e.g January
W=`date +%V` # Week Number e.g 37
VER=2.5 # Version Number
LOGFILE=$BACKUPDIR/$DBHOST-`date +%N`.log # Logfile Name
LOGERR=$BACKUPDIR/ERRORS_$DBHOST-`date +%N`.log # Logfile Name
BACKUPFILES=""
OPT="--quote-names --opt" # OPT string for use with mysqldump
( see man mysqldump )
# Add --compress mysqldump option to $OPT
if [ "$COMMCOMP" = "yes" ];
then
OPT="$OPT --compress"
fi
# Add --compress mysqldump option to $OPT
if [ "$MAX_ALLOWED_PACKET" ];
then
OPT="$OPT --max_allowed_packet=$MAX_ALLOWED_PACKET"
fi
# Create required directories
if [ ! -e "$BACKUPDIR" ] # Check Backup Directory exists.
then
mkdir -p "$BACKUPDIR"
fi
if [ ! -e "$BACKUPDIR/daily" ] # Check Daily Directory exists.
then
mkdir -p "$BACKUPDIR/daily"
fi
if [ ! -e "$BACKUPDIR/weekly" ] # Check Weekly Directory exists.
then
mkdir -p "$BACKUPDIR/weekly"
fi
if [ ! -e "$BACKUPDIR/monthly" ] # Check Monthly Directory exists.
then
mkdir -p "$BACKUPDIR/monthly"
fi
if [ "$LATEST" = "yes" ]
then
if [ ! -e "$BACKUPDIR/latest" ] # Check Latest Directory exists.
then
mkdir -p "$BACKUPDIR/latest"
fi
eval rm -fv "$BACKUPDIR/latest/*"
fi
# IO redirection for logging.
touch $LOGFILE
exec 6>&1 # Link file descriptor #6 with stdout.
# Saves stdout.
exec > $LOGFILE # stdout replaced with file $LOGFILE.
touch $LOGERR
exec 7>&2 # Link file descriptor #7 with stderr.
# Saves stderr.
exec 2> $LOGERR # stderr replaced with file $LOGERR.
# Functions
# Database dump function
dbdump () {
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT $1 > $2
return 0
}
dbdump_table () {
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT $1
$2 > $3
return 0
}
# Database dump function with pipe compression plus latest copy
dbdump_comp () {
if [ "$COMP" = "gzip" ]; then
echo
echo Backup Information for "$1.gz"
SUFFIX=".gz"
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT
$1 | gzip > $2$SUFFIX
gzip -l "$1.gz"
elif [ "$COMP" = "bzip2" ]; then
echo Compression information for "$1.bz2"
SUFFIX=".bz2"
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT
$1 | bzip2 -v 2>&1 > $2$SUFFIX
else
echo "No compression option set, check advanced settings"
fi
return 0
}
dbdump_table_comp () {
if [ "$COMP" = "gzip" ]; then
echo
echo Backup Information for "$3.gz"
SUFFIX=".gz"
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT
$1 $2 | gzip > $3$SUFFIX
gzip -l "$3.gz"
elif [ "$COMP" = "bzip2" ]; then
echo Compression information for "$3.bz2"
SUFFIX=".bz2"
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST $OPT
$1 $2 | bzip2 -v 2>&1 > $3$SUFFIX
else
echo "No compression option set, check advanced settings"
fi
return 0
}
# Compression function plus latest copy
SUFFIX=""
compression () {
if [ "$COMP" = "gzip" ]; then
gzip -f "$1"
echo
echo Backup Information for "$1.gz"
gzip -l "$1.gz"
SUFFIX=".gz"
elif [ "$COMP" = "bzip2" ]; then
echo Compression information for "$1.bz2"
bzip2 -f -v $1 2>&1
SUFFIX=".bz2"
else
echo "No compression option set, check advanced settings"
fi
if [ "$LATEST" = "yes" ]; then
cp $1$SUFFIX "$BACKUPDIR/latest/"
fi
return 0
}
# Run command before we begin
if [ "$PREBACKUP" ]
then
echo
======================================================================
echo "Prebackup command output."
echo
eval $PREBACKUP
echo
echo
======================================================================
echo
fi
# Add --ignore-table options to $OPT
if [ -n "$TABLEEXCLUDE" ]; then
for table in $TABLEEXCLUDE ; do
OPT="${OPT} --ignore-table=${table}"
done
fi
if [ "$SEPDIR" = "yes" ]; then # Check if CREATE DATABSE should be
included in Dump
if [ "$CREATE_DATABASE" = "no" ]; then
OPT="$OPT --no-create-db"
elif [ "$PERTABLE" = "yes" ]; then
OPT="$OPT --no-create-db"
else
OPT="$OPT --databases"
fi
else
OPT="$OPT --databases"
fi
# Hostname for LOG information
if [ "$DBHOST" = "localhost" ]; then
HOST=`hostname`
if [ "$SOCKET" ]; then
OPT="$OPT --socket=$SOCKET"
fi
else
HOST=$DBHOST
fi
# If backing up all DBs on the server
if [ "$DBNAMES" = "all" ]; then
DBNAMES="`mysql --user=$USERNAME --password=$PASSWORD
--host=$DBHOST --batch --skip-column-names -e "show databases"| sed 's/
/%/g'`"
# If DBs are excluded
for exclude in $DBEXCLUDE
do
DBNAMES=`echo $DBNAMES | sed "s/\b$exclude\b//g"`
done
MDBNAMES=$DBNAMES
fi
echo ======================================================================
echo AutoMySQLBackup VER $VER
echo http://sourceforge.net/projects/automysqlbackup/
echo
echo Backup of Database Server - $HOST
echo ======================================================================
# Test is seperate DB backups are required
if [ "$SEPDIR" = "yes" ]; then
echo Backup Start Time `date`
echo ======================================================================
# Monthly Full Backup of all Databases
if [ $DOM = "01" ]; then
for MDB in $MDBNAMES
do
# Prepare $DB for using
MDB="`echo $MDB | sed 's/%/ /g'`"
if [ "$PERTABLE" = "yes" ]; # Check backup per table
then # Start Monthly DB backup per table
echo Monthly Backup of $MDB per table...
TABLES="`mysql --user=$USERNAME --password=$PASSWORD
--host=$DBHOST --batch --skip-column-names -e "show tables" $MDB| sed
's/ /%/g'`"
for TABLE in $TABLES
do
if [ ! -e
"$BACKUPDIR/monthly/${MDB}_pertable/${MDB}_pertable_$DATE.$M.$MDB" ] #
Check Monthly DB per table Directory exists.
then
mkdir -p
"$BACKUPDIR/monthly/${MDB}_pertable/${MDB}_pertable_$DATE.$M.$MDB"
fi
if [ "$PIPECOMP" = "yes" ]; then
dbdump_table_comp "$MDB" "$TABLE"
"$BACKUPDIR/monthly/${MDB}_pertable/${MDB}_pertable_$DATE.$M.$MDB/$TABLE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/monthly/${MDB}_pertable/${MDB}_pertable_$DATE.$M.$MDB/$TABLE.sql$SUFFIX"
else
dbdump_table "$MDB" "$TABLE"
"$BACKUPDIR/monthly/${MDB}_pertable/${MDB}_pertable_$DATE.$M.$MDB/$TABLE.sql"
compression
"$BACKUPDIR/monthly/${MDB}_pertable/${MDB}_pertable_$DATE.$M.$MDB/$TABLE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/monthly/${MDB}_pertable/${MDB}_pertable_$DATE.$M.$MDB/$TABLE.sql$SUFFIX"
fi
done
echo
----------------------------------------------------------------------
else # Start Monthly DB full
if [ ! -e "$BACKUPDIR/monthly/$MDB" ] # Check
Monthly DB Directory exists.
then
mkdir -p "$BACKUPDIR/monthly/$MDB"
fi
echo Monthly Backup of $MDB...
if [ "$PIPECOMP" = "yes" ]; then
dbdump_comp "$MDB"
"$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql$SUFFIX"
else
dbdump "$MDB"
"$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql"
compression
"$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/monthly/$MDB/${MDB}_$DATE.$M.$MDB.sql$SUFFIX"
fi
echo
----------------------------------------------------------------------
fi
done
fi
for DB in $DBNAMES
do
# Prepare $DB for using
DB="`echo $DB | sed 's/%/ /g'`"
# Create Seperate directory for each DB
if [ "$PERTABLE" = "yes" ];
then
if [ ! -e
"$BACKUPDIR/daily/${DB}_pertable/${DB}_pertable_$DATE.$DOW" ] #
Check Daily DB per table Directory exists.
then
mkdir -p
"$BACKUPDIR/daily/${DB}_pertable/${DB}_pertable_$DATE.$DOW"
fi
if [ ! -e
"$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$W.$DATE" ]
# Check Weekly DB per table Directory exists.
then
mkdir -p
"$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$W.$DATE"
fi
else
if [ ! -e "$BACKUPDIR/daily/$DB" ] # Check Daily DB
Directory exists.
then
mkdir -p "$BACKUPDIR/daily/$DB"
fi
if [ ! -e "$BACKUPDIR/weekly/$DB" ] # Check Weekly DB
Directory exists.
then
mkdir -p "$BACKUPDIR/weekly/$DB"
fi
fi
# Weekly Backup
if [ $DNOW = $DOWEEKLY ]; then
echo Weekly Backup of Database \( $DB \)
if [ "$PERTABLE" = "yes" ];
then
echo Rotating 5 weeks Backups...
if [ "$W" -le 05 ];then
REMW=`expr 48 + $W`
elif [ "$W" -lt 15 ];then
REMW=0`expr $W - 5`
else
REMW=`expr $W - 5`
fi
eval rm -rfv
"$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$REMW.*"
echo
TABLES="`mysql --user=$USERNAME --password=$PASSWORD
--host=$DBHOST --batch --skip-column-names -e "show tables" $DB| sed 's/
/%/g'`"
for TABLE in $TABLES
do
if [ "$PIPECOMP" = "yes" ]; then
dbdump_table_comp "$DB" "$TABLE"
"$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$W.$DATE/$TABLE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$W.$DATE/$TABLE.sql$SUFFIX"
else
dbdump_table "$DB" "$TABLE"
"$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$W.$DATE/$TABLE.sql"
compression
"$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$W.$DATE/$TABLE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/weekly/${DB}_pertable/${DB}_pertable.week.$W.$DATE/$TABLE.sql$SUFFIX"
fi
done
echo
----------------------------------------------------------------------
else
echo Rotating 5 weeks Backups...
if [ "$W" -le 05 ];then
REMW=`expr 48 + $W`
elif [ "$W" -lt 15 ];then
REMW=0`expr $W - 5`
else
REMW=`expr $W - 5`
fi
eval rm -fv "$BACKUPDIR/weekly/$DB/${DB}_week.$REMW.*"
echo
if [ "$PIPECOMP" = "yes" ]; then
dbdump_comp "$DB"
"$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql$SUFFIX"
else
dbdump "$DB"
"$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql"
compression
"$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/weekly/$DB/${DB}_week.$W.$DATE.sql$SUFFIX"
fi
echo
----------------------------------------------------------------------
fi
# Daily Backup
else
echo Daily Backup of Database \( $DB \)
if [ "$PERTABLE" = "yes" ];
then
echo Rotating last weeks Backup...
eval rm -rfv
"$BACKUPDIR/daily/$DB/${DB}_pertable/*_pertable.*.$DOW"
TABLES="`mysql --user=$USERNAME --password=$PASSWORD
--host=$DBHOST --batch --skip-column-names -e "show tables" $DB| sed 's/
/%/g'`"
for TABLE in $TABLES
do
if [ "$PIPECOMP" = "yes" ]; then
dbdump_table_comp "$DB" "$TABLE"
"$BACKUPDIR/daily/${DB}_pertable/${DB}_pertable_$DATE.$DOW/$TABLE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/daily/${DB}_pertable/${DB}_pertable_$DATE.$DOW/$TABLE.sql$SUFFIX"
else
dbdump_table "$DB" "$TABLE"
"$BACKUPDIR/daily/${DB}_pertable/${DB}_pertable_$DATE.$DOW/$TABLE.sql"
compression
"$BACKUPDIR/daily/${DB}_pertable/${DB}_pertable_$DATE.$DOW/$TABLE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/daily/${DB}_pertable/${DB}_pertable_$DATE.$DOW/$TABLE.sql$SUFFIX"
fi
done
echo
----------------------------------------------------------------------
else
echo Rotating last weeks Backup...
eval rm -fv "$BACKUPDIR/daily/$DB/*.$DOW.sql.*"
echo
if [ "$PIPECOMP" = "yes" ]; then
dbdump_comp "$DB"
"$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql$SUFFIX"
else
dbdump "$DB" "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql"
compression "$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/daily/$DB/${DB}_$DATE.$DOW.sql$SUFFIX"
fi
echo
----------------------------------------------------------------------
fi
fi
done
echo Backup End `date`
echo ======================================================================
else # One backup file for all DBs
echo Backup Start `date`
echo ======================================================================
# Monthly Full Backup of all Databases
if [ $DOM = "01" ]; then
echo Monthly full Backup of \( $MDBNAMES \)...
if [ "$PIPECOMP" = "yes" ]; then
dbdump_comp "$MDBNAMES"
"$BACKUPDIR/monthly/$DATE.$M.all-databases.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/monthly/$DATE.$M.all-databases.sql$SUFFIX"
else
dbdump "$MDBNAMES"
"$BACKUPDIR/monthly/$DATE.$M.all-databases.sql"
compression "$BACKUPDIR/monthly/$DATE.$M.all-databases.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/monthly/$DATE.$M.all-databases.sql$SUFFIX"
fi
echo
----------------------------------------------------------------------
fi
# Weekly Backup
if [ $DNOW = $DOWEEKLY ]; then
echo Weekly Backup of Databases \( $DBNAMES \)
echo
echo Rotating 5 weeks Backups...
if [ "$W" -le 05 ];then
REMW=`expr 48 + $W`
elif [ "$W" -lt 15 ];then
REMW=0`expr $W - 5`
else
REMW=`expr $W - 5`
fi
eval rm -fv "$BACKUPDIR/weekly/week.$REMW.*"
echo
if [ "$PIPECOMP" = "yes" ]; then
dbdump_comp "$DBNAMES"
"$BACKUPDIR/weekly/week.$W.$DATE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/weekly/week.$W.$DATE.sql$SUFFIX"
else
dbdump "$DBNAMES" "$BACKUPDIR/weekly/week.$W.$DATE.sql"
compression "$BACKUPDIR/weekly/week.$W.$DATE.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/weekly/week.$W.$DATE.sql$SUFFIX"
fi
echo
----------------------------------------------------------------------
# Daily Backup
else
echo Daily Backup of Databases \( $DBNAMES \)
echo
echo Rotating last weeks Backup...
eval rm -fv "$BACKUPDIR/daily/*.$DOW.sql.*"
echo
if [ "$PIPECOMP" = "yes" ]; then
dbdump_comp "$DBNAMES" "$BACKUPDIR/daily/$DATE.$DOW.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/daily/$DATE.$DOW.sql$SUFFIX"
else
dbdump "$DBNAMES" "$BACKUPDIR/daily/$DATE.$DOW.sql"
compression "$BACKUPDIR/daily/$DATE.$DOW.sql"
BACKUPFILES="$BACKUPFILES
$BACKUPDIR/daily/$DATE.$DOW.sql$SUFFIX"
fi
echo
----------------------------------------------------------------------
fi
echo Backup End Time `date`
echo ======================================================================
fi
echo Total disk space used for backup storage..
echo Size - Location
echo `du -hs "$BACKUPDIR"`
echo
echo ======================================================================
echo If you find AutoMySQLBackup valuable please make a donation at
echo http://sourceforge.net/project/project_donations.php?group_id=101066
echo ======================================================================
# Run command when we're done
if [ "$POSTBACKUP" ]
then
echo
======================================================================
echo "Postbackup command output."
echo
eval $POSTBACKUP
echo
echo
======================================================================
fi
#Clean up IO redirection
exec 1>&6 6>&- # Restore stdout and close file descriptor #6.
exec 1>&7 7>&- # Restore stdout and close file descriptor #7.
if [ "$MAILCONTENT" = "files" ]
then
if [ -s "$LOGERR" ]
then
# Include error log if is larger than zero.
BACKUPFILES="$BACKUPFILES $LOGERR"
ERRORNOTE="WARNING: Error Reported - "
fi
#Get backup size
ATTSIZE=`du -c $BACKUPFILES | grep "[[:digit:][:space:]]total$" |sed
s/\s*total//`
if [ $MAXATTSIZE -ge $ATTSIZE ]
then
BACKUPFILES=`echo "$BACKUPFILES" | sed -e "s# # -a #g"`
#enable multiple attachments
mutt -s "$ERRORNOTE MySQL Backup Log and SQL Files for $HOST -
$DATE" $BACKUPFILES $MAILADDR < $LOGFILE #send via mutt
else
cat "$LOGFILE" | mail -s "WARNING! - MySQL Backup exceeds set
maximum attachment size on $HOST - $DATE" $MAILADDR
fi
elif [ "$MAILCONTENT" = "log" ]
then
cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST - $DATE" $MAILADDR
if [ -s "$LOGERR" ]
then
cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error
Log for $HOST - $DATE" $MAILADDR
fi
elif [ "$MAILCONTENT" = "quiet" ]
then
if [ -s "$LOGERR" ]
then
cat "$LOGERR" | mail -s "ERRORS REPORTED: MySQL Backup error
Log for $HOST - $DATE" $MAILADDR
cat "$LOGFILE" | mail -s "MySQL Backup Log for $HOST -
$DATE" $MAILADDR
fi
else
if [ -s "$LOGERR" ]
then
cat "$LOGFILE"
echo
echo "###### WARNING ######"
echo "Errors reported during AutoMySQLBackup execution..
Backup failed"
echo "Error log below.."
cat "$LOGERR"
else
cat "$LOGFILE"
fi
fi
if [ -s "$LOGERR" ]
then
STATUS=1
else
STATUS=0
fi
# Clean up Logfile
eval rm -f "$LOGFILE"
eval rm -f "$LOGERR"
exit $STATUS
|
|
From: Gonzillaaa <gonzillaaa@gm...> - 2007-01-17 14:26:15
|
hi there just upgraded to version 2.5 and I'm getting the following on stdout: ###### WARNING ###### Errors reported during AutoMySQLBackup execution.. Backup failed Error log below.. rm: /Users/gonzalo/Backup/MySQL/daily/: is a directory /usr/local/bin/automysqlbackup: line 408: $2: ambiguous redirect gzip: /Users/gonzalo/Backup/MySQL/daily/ xbow_data/ xbow_data_2007-01-17_14h10m.Wednesday.sql: No such file or directory gzip: /Users/gonzalo/Backup/MySQL/daily/ xbow_data/ xbow_data_2007-01-17_14h10m.Wednesday.sql.gz: No such file or directory cp: xbow_data_2007-01-17_14h10m.Wednesday.sql.gz: No such file or directory cp: xbow_data/: No such file or directory cp: /Users/gonzalo/Backup/MySQL/daily/ is a directory (not copied). it only happens with the db xbow_data which contains quite large tables, I have set the MAX_ALLOWED_PACKET=50MB the script is running on localhost using osx tiger and MySQL 5.0.19-standard any clues would be greatly appreciated. |
|
From: Eduardo Casarero <ecasarero@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 <wipe_out@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 > > |