On 4 Aug 2008, at 7:05 pm, [EMAIL PROTECTED] 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. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
