automysqlbackup-users Mailing List for AutoMySQLBackup (Page 2)
Automatic MySQL Backup
Brought to you by:
wipe_out
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: Ward L. <wa...@lo...> - 2011-06-06 06:32:35
|
I see that mysqlhotcopy is only available for myIsam and currently we use innoDB tables.. Do you have another solution? 2011/6/2 Ward Loockx <wa...@lo...> > 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 <wip...@us...> > >> 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 <wa...@lo...> 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 >>> Aut...@li... >>> 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 >> Aut...@li... >> https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users >> >> > |
From: Justin B. <ju...@ws...> - 2011-06-02 20:11:48
|
Hello, In the documentation it says that the daily backups should rotate after a week, however, I just checked and another backup popped in from last Thursday. Am I missing something? Thanks! Justin |
From: Ward L. <wa...@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 <wip...@us...> > 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 <wa...@lo...> 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 >> Aut...@li... >> 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 > Aut...@li... > https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users > > |
From: Wipe_Out <wip...@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 <wa...@lo...> 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 > Aut...@li... > https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users > > |
From: Ward L. <wa...@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 M. <st...@rt...> - 2011-03-24 07:38:46
|
Hello when I try and run the script with MAILCONTENT="files" I get the following error. stewart@li204-167:~/scripts$ ./backup.sh Can't stat st...@rt...: No such file or directory st...@rt...: unable to attach file. Can someone explain why this is happening? Thanks in advance for any help. |
From: Kyle H. <kyl...@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 r. <kas...@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 J. <rj...@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 > Aut...@li... > https://lists.sourceforge.net/lists/listinfo/automysqlbackup-users > |
From: WipeOut <wip...@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 <wip...@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 S. <ad...@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:ad...@pe...> AOL/Yahoo/Skype/Gizmo ID: perlucida Web Site <http://perlucida.com> |
From: WipeOut <wip...@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 S. <ad...@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:ad...@pe...> AOL/Yahoo/Skype/Gizmo ID: perlucida Web Site <http://perlucida.com> |
From: Adrian S. <ad...@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:ad...@pe...> AOL/Yahoo/Skype/Gizmo ID: perlucida Web Site <http://perlucida.com> |
From: Russell J. <rj...@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 B. <Jav...@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 jav...@is... -------------------------------------------- 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 www.isotrol.com |
From: BenRifkah Bergsten-B. <be...@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 <wip...@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 f. <af...@ci...> - 2007-08-15 04:33:14
|
----- BenRifkah Bergsten-Buret <be...@sp...> 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-B. <be...@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 <mic...@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 O. <ro...@sy...> - 2007-08-03 10:33:40
|
Hi all, Is it possible to use automysqlbackup to backup InnoDB databases? Robert |
From: Adam F. <af...@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 <gon...@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. |