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

[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 development instance (yes, backward), but we don't
> want to carry the ~6GB of *ticket and attachment*
> data (what else?) over to development.
>
> Essentially, we want the same environment in development
> as production, but with empty queues.

Warning: Do not try this.  It seemed to work fine, then
weird things started popping up.  Instead, dump everything
from production, restore everything on the dev server,
then shred the tickets on the dev server.