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.
If a tool exists that can retain and, follow
referential relationships (e.g., grab the first XXX rows from this
table, and all the HAS_A and HAS_MANY rows linked to those XXX
rows) … ?
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.