Re: [rt-users] Dump all except tickets+attachments?

2011-08-18 Thread Darren Spruell
A bunch of people wrote: > [...] This has been an informative thread, thanks for the responses. -- Darren Spruell phatbuck...@gmail.com RT Training Sessions (http://bestpractical.com/services/training.html) * Chicago, IL, USA September 26 & 27, 2011 * San Francisco, CA, USA October

Re: [rt-users] Dump all except tickets+attachments?

2011-08-18 Thread Chr. von Stuckrad
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,10

Re: [rt-users] Dump all except tickets+attachments?

2011-08-18 Thread Jeff Blaine
I added this before I followed up to this thread with "Don't try this (dump partial DB and transfer): http://requesttracker.wikia.com/wiki/Shredder == Shred ALL TICKETS WARNING WARNING WARNING: If for some reason you want to reset your

Re: [rt-users] Dump all except tickets+attachments?

2011-08-18 Thread Ruslan Zakirov
Hello, WARNING: Only for quick shredding testing environment from all tickets on 3.8+. Use this tools in production very carefully and always test such destructive actions in a test environment. Solution with validator: DELETE FROM Tickets; ./sbin/rt-validator -c --resolve Solution with rt-del

Re: [rt-users] Dump all except tickets+attachments?

2011-08-18 Thread Kevin Falcone
On Thu, Aug 18, 2011 at 02:02:36PM +0200, Chr. von Stuckrad wrote: > On Wed, 17 Aug 2011, Darren Spruell wrote: > > > into an error to the effect of too many tickets specified by the > > shredder resulting in too long of a GET request URI length for the > > server. I concluded that shredding that

Re: [rt-users] Dump all except tickets+attachments?

2011-08-18 Thread Chr. von Stuckrad
On Wed, 17 Aug 2011, Darren Spruell wrote: > into an error to the effect of too many tickets specified by the > shredder resulting in too long of a GET request URI length for the > server. I concluded that shredding that many tickets from the UI > wasn't going to work and there must be a better wa

Re: [rt-users] Dump all except tickets+attachments?

2011-08-17 Thread Darren Spruell
On Wed, Aug 17, 2011 at 8:01 AM, Jeff Blaine wrote: > Replying to my thread starter from a few months ago. > > On 6/23/2011 11:32 AM, Jeff Blaine wrote: >> >> If anyone has any clever advice as to how to about this, >> I'd love to hear it. >> >> RT 3.8.7 + security patches, PostgreSQL 8.1.23, RHEL

Re: [rt-users] Dump all except tickets+attachments?

2011-08-17 Thread Jeff Blaine
Replying to my thread starter from a few months ago. On 6/23/2011 11:32 AM, Jeff Blaine wrote: If anyone has any clever advice as to how to about this, I'd love to hear it. RT 3.8.7 + security patches, PostgreSQL 8.1.23, RHEL5 We need to replicate our production RT instance's data to a develop

Re: [rt-users] Dump all except tickets+attachments?

2011-06-23 Thread Jeff Blaine
laine Sent: 23 June 2011 16:33 To: rt-users@lists.bestpractical.com Subject: [rt-users] Dump all except tickets+attachments? If anyone has any clever advice as to how to about this, I'd love to hear it. RT 3.8.7 + security patches, PostgreSQL 8.1.23, RHEL5 We need to replicate our production RT instance

Re: [rt-users] Dump all except tickets+attachments?

2011-06-23 Thread Raed El-Hames
ts.bestpractical.com > Subject: [rt-users] Dump all except tickets+attachments? > > If anyone has any clever advice as to how to about this, > I'd love to hear it. > > RT 3.8.7 + security patches, PostgreSQL 8.1.23, RHEL5 > > We need to replicate our production RT ins

[rt-users] Dump all except tickets+attachments?

2011-06-23 Thread Jeff Blaine
If anyone has any clever advice as to how to about this, I'd love to hear it. RT 3.8.7 + security patches, PostgreSQL 8.1.23, RHEL5 We need to replicate our production RT instance's data to a development instance (yes, backward), but we don't want to carry the ~6GB of *ticket and attachment* dat