[rt-users] Perl script to dump mysql db transactions?

[Todd Chapman]

On Wed, Mar 02, 2005 at 05:48:27PM -0800, Doug Barton wrote:
> Howdy,
> 
> Under different circumstances I would not make such a naked plea for 
> assistance, however time is of the essence (when is it not?) and I'm hoping 
> that this is one of those trivial issues that someone with more experience 
> has already tackled.
> 
> I'm fairly competent with Perl coding, but not much experienced in mysql. 
> What I need to do is generate a list of all the transactions (i.e., 
> activity of any sort) that have occurred in a given RT queue during a 
> specified time period. Say for example, I might want to run a cron script 
> at 12:01 am every night that dumped the previous day's transactions to a 
> text file.
> 
> I can handle issues related to formatting, printing to file, etc., what I'm 
> hoping someone has handy in their tool box is the code to get mysql to 
> "tell me everything that's changed in this table between time X and time 
> Y." Or, if this is a trivial exercise if someone could point me to the Fine 
> Manual I should read, I'd be grateful for that kind of help as well.
> 
> Thanks,
> 
> Doug
> 

If you are competent at Perl, why not use the Perl RT API to do this?