On Thu, 18 Aug 2011, Jeff Blaine wrote:

> and duplicate it onto a development box but not have the huge
> database full of tickets and ticket-related data.

Exactly what we wanted to do then.

> Bourne shell syntax is shown below:
...
> SHREDDED=`rt-shredder --plugin "Tickets=query,id > 0;limit,100"
... -------------------------------------------------^^^^^^^^^^^

And THIS ^^^^ seems to be the exact difference to what I tried then,
you made it into a loop of 100 Tickets each until empty ...
Needing the duplicate 'tomorrow morning' I never tried it that way,
but thanks for showing, that it 'should have worked' :-))

Would you consider restricting the 'query' to one specific queue
and cleaning that queue completely, to be safe enough for applying
it to a production-RT? (We did split an RT into two completely
independent Hosts. Everything is already logically independent,
both are working with copies of the complete former state, changeing
only 'their half' of the data. Only the leftover halves could be
shredded (same problem again, but 'more dangerous' on a working
instance which must not be damaged).

Stucki

-- 
Christoph von Stuckrad      * * |nickname |Mail <[email protected]> \
Freie Universitaet Berlin   |/_*|'stucki' |Tel(Mo.,Mi.):+49 30 838-75 459|
Mathematik & Informatik EDV |\ *|if online|  (Di,Do,Fr):+49 30 77 39 6600|
Takustr. 9 / 14195 Berlin   * * |on IRCnet|Fax(home):   +49 30 77 39 6601/
--------
RT Training Sessions (http://bestpractical.com/services/training.html)
*  Chicago, IL, USA  September 26 & 27, 2011
*  San Francisco, CA, USA  October 18 & 19, 2011
*  Washington DC, USA  October 31 & November 1, 2011
*  Melbourne VIC, Australia  November 28 & 29, 2011
*  Barcelona, Spain  November 28 & 29, 2011

Reply via email to