[rt-users] Mysql question

[Tim Cutts]

On 4 Aug 2008, at 7:05 pm, chaim.rieger at gmail.com wrote:

> Does anyone know of a tool (ideally Linux command line, and ideally
> ideally with source or PowerPC binary package(s) available) that grab
> a partial snapshot of a MySQL database?  Trying to setup a development
> server that obviously can't hit the 'live' database, but don't want
> to, even periodically, replicate a 60+ GB database if I don't have to,
> especially when I only really need a few hundred rows from each table
> to do what I need to do.

I'd do it once, load a complete copy into another RT instance, and  
then use RT::Shredder to remove the vast majority of the tickets and  
their dependent information (which will take a loooong time!) dump  
your newly pruned test RT instance, and use that for future tests?

Tim


-- 
 The Wellcome Trust Sanger Institute is operated by Genome Research 
 Limited, a charity registered in England with number 1021457 and a 
 company registered in England with number 2742969, whose registered 
 office is 215 Euston Road, London, NW1 2BE.