Trimming a database for local development

[wim.lustenhouwer]

Hi all,

I've recently acquired a database dump from a production server. This database is gigabytes in size and I was wondering if there was an easy way tot trim this database to the bare essentials. I'm thinking one document of any type. It's for local development after all.

[William Borg Barthet]

Hi there,

you can probably safely truncate the REPOSITORY_JOURNAL table. Otherwise it's pretty hard to remove parts of the repository from the database level AFAIK. If you are doing local development, you might be better off using the default H2 file database and manually exporting and importing a subset of the content using the console.

HTH

William

On 27 August 2015 at 07:51, wim.lustenhouwer <wim.lust...@finalist.com> wrote:

Hi all,

I've recently acquired a database dump from a production server. This database is gigabytes in size and I was wondering if there was an easy way tot trim this database to the bare essentials. I'm thinking one document of any type. It's for local development after all.

--
Hippo Community Group: The place for all discussions and announcements about Hippo CMS (and HST, repository etc. etc.)
 
To post to this group, send email to hippo-c...@googlegroups.com
RSS: https://groups.google.com/group/hippo-community/feed/rss_v2_0_msgs.xml?num=50
---
You received this message because you are subscribed to the Google Groups "Hippo Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hippo-communi...@googlegroups.com.
Visit this group at http://groups.google.com/group/hippo-community.
For more options, visit https://groups.google.com/d/optout.

--

Amsterdam - Oosteinde 11, 1017 WT Amsterdam
Boston - 745 Atlantic Avenue, Boston, MA 02111

 
US +1 877 414 4776 (toll free)
Europe +31(0)20 522 4466
www.onehippo.com