Hi JJ, Not really a MySQL question but more a UNIX/Linux question. <UNIX 101> If mysqldump encounters an error it will like all well behaved programs write an error message to stderr. You can also from your script check the error return from the command and perform additional actions. I would guess that this will be a repeating operation so I would suggest you use 'cron' see 'man cron' at the unix prompt. Creating an entry in your cron that runs a scripts will mail you nothing if there is no output from the progam IE it worked or you can add a success message and you will get a mail every time. Either way if there is an error the text of the error will get mailed to you. </UNIX 101> Hope this helps, ken
----- Original Message ----- From: "Jai Jones" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 13, 2004 3:22 AM Subject: Enabling Logging > Hi, > > I am a little confused on how to get logging working, perhaps some advanced > users can help :) > > Here's what I'm trying to do, I am backing up my MySQL data using a shell > script and mysqldump. I would like to be able to send an email notification > to myself to know that the dump worked. > > I was thinking of tac'ing or tail'ing the last few entries of a mysql (or > mysqldump??) log and pipping it to an email. Does this sound like a good > idea? > > It appears my server is not logging by default, how do I enable a log that > would store this info, or am I looking at this the wrong way. > > Thanks :) > JJ > > _________________________________________________________________ > MSN Messenger: instale grátis e converse com seus amigos. > http://messenger.msn.com.br > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
