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

[Jeff Blaine]

Roy,

Thanks.  What about "links"?  Anyone with any other
ideas?

So basically, this, which excludes transactions, sessions,
tickets, attachments:

for t in acl attributes cachedgroupmembers customfields \
customfieldvalues fm_articles fm_classes fm_objecttopics \
fm_topics groupmembers groups links objectcustomfields \
objectcustomfieldvalues principals queues scripactions \
scripconditions scrips templates users
do
     pg_dump -U postgres --table $t rt3 > dump_${t}.sql
done

Then I suppose a 'make initialize-database' on the
development server and start loading the data, eh?

On 6/23/2011 12:05 PM, Raed El-Hames wrote:
> Jeff,
>
> If you are in a position to do it via sql , then I would suggest you take this route.
> By via sql I mean you are able to do statements like (insert into development_db.Users (select * from production_db.Users) etc ..
> If you ignoring Tickets and Attachments I would also ignore the Transactions table content , unless you care about change history for users/groups.
> Its also possible to ignore objectcustomfields and objectcustomfieldvalues content unless you are using users/groups/queues custom fields which are not very common.
> And also ignore sessions table content
>
> Tables like groups / GroupMembers and CachedGroupMembers are tricky and hard to get right via sql, if you start with the Groups table and select * from Groups where Domain != 'RT::Ticket-Role', then you should be able to do the GroupMembers by select * from production_db.GroupMembers where GroupId in (select Id from development_db.Groups)
> As for CachedGroupMembers, its far more tricky and please look into it in more details, but for a starting point I would suggest you do the same select as GroupMembers.
>
> Hope that helps,
> Regards;
> Roy
>
>
>
>>
> Visit our website today www.daisygroupplc.com
>
> Registered Office: Daisy House, Lindred Road Business Park, Nelson, Lancashire BB9 5SR
> Company Registration Number: 4145329 |   VAT Number: 722471355
> Daisy Communications Limited is a company registered in England and Wales.
> DISCLAIMER
>
> This email (including any attachments) is strictly confidential and may also be legally privileged. If the recipient has received this email in error please notify the sender and do not read, print, re-transmit, store or act in reliance on the email or its attachments and immediately delete this email and its attachments from the recipient's system. Daisy Communications Limited cannot accept liability for any breaches of confidence arising through use of email. Employees of Daisy Communications Limited are expressly required not to make any defamatory statements and not to infringe or authorise any infringement of copyright or any other legal right by email communications. Any such communication is contrary to the company's policy and outside the scope of the employment of the individual concerned. Daisy Communications Limited will not accept any liability in respect of such a communication, and the employee responsible will be personally liable for any damages or other li
ability arising.
>
> If you are the intended recipient of this email please ensure that neither the email nor any attachments are copied to third parties outside your organisation or saved without the written permission of the sender.  In the event of any unauthorised copying or forwarding, the recipient will be required to indemnify Daisy Communications Limited against any claim for loss or damage caused by any viruses or otherwise.
>
> WARNING: Computer viruses can be transmitted by email. The recipient should check this email and any attachments for the presence of viruses. Daisy Communications Limited accepts no liability for any damage caused by any virus transmitted by this email or any attachments.
> NOTICE TO CUSTOMERS
> If you have ordered a telephone number from Daisy Communications Limited (non-geographic or new line installation) please do NOT arrange for any form of advertising until the number is live and tested.
>
>
> -----Original Message-----
>> From: rt-users-bounces at lists.bestpractical.com [mailto:rt-users-
>> bounces at lists.bestpractical.com] On Behalf Of Jeff Blaine
>> Sent: 23 June 2011 16:33
>> To: rt-users at 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'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.
>>
>> Advice?
>>
>> You are now connected to database "rt3".
>> rt3=# \dt
>>                     List of relations
>>    Schema |          Name           | Type  |  Owner
>> --------+-------------------------+-------+----------
>>    public | acl                     | table | postgres
>>    public | attachments             | table | postgres
>>    public | attributes              | table | postgres
>>    public | cachedgroupmembers      | table | postgres
>>    public | customfields            | table | postgres
>>    public | customfieldvalues       | table | postgres
>>    public | fm_articles             | table | rt_user
>>    public | fm_classes              | table | rt_user
>>    public | fm_objecttopics         | table | rt_user
>>    public | fm_topics               | table | rt_user
>>    public | groupmembers            | table | postgres
>>    public | groups                  | table | postgres
>>    public | links                   | table | postgres
>>    public | objectcustomfields      | table | postgres
>>    public | objectcustomfieldvalues | table | postgres
>>    public | principals              | table | postgres
>>    public | queues                  | table | postgres
>>    public | scripactions            | table | postgres
>>    public | scripconditions         | table | postgres
>>    public | scrips                  | table | postgres
>>    public | sessions                | table | postgres
>>    public | templates               | table | postgres
>>    public | tickets                 | table | postgres
>>    public | transactions            | table | postgres
>>    public | users                   | table | postgres
>> (25 rows)
>>
>> --------
>> 2011 Training: http://bestpractical.com/services/training.html
>