[opencms-dev] Managing database size

[Bart Elberg]

Alex,

We are using 4.6.1 and don't have the time to update to 5.0 and retest 
everything.  It's good to hear that this issue is being addressed in the 
new version.

For the export, here are the options that I think are correct:
  no  - exclude system folders
  yes - include group- and userdata
  no  - exclude files unchanged in the current project

I assume from the response that the import does NOT import the history. 
 Could you confirm this?
Is there any other data that is lost/changed in this process?  We have 
separate tables that contain application data and will be exported 
separately.  This data is related to the OpenCms data by the CMS_USER.ID 
field.  Hopefully the IDs are not changed during the export/import process?

Thanks for your help!

Bart

-------------------
Alexander Kandzior wrote:

>Hi Bart,
>
>managing history age this is a standard feature in in the 5.0 beta 1,
>but not in the previous releases. In the 5.0, there is a new icon in the
>Adminstration -> Project Management which lets you specify the max age
>of history contents. 
>
>A workaround for older releases:
>1. Backup your old database
>2. Make an export of your "/" folder (ie. everything) using
>Administration -> Databases Management -> Export
>3. Setup a new instance of OpenCms in the version you are currently
>using with the OpenCms setup wizard
>4. Give the database of this new instance a different name (in the
>dialog of the wizard)
>5. Import your content in this new instance
>6. Check if everything still works (important point :)
>7. If so, drop the old database and rename the new database to the old
>name using database tools
>
>
>Best Regards,
>Alex.
>
>Alexander Kandzior
>OpenCms Group / Alkacon Software
>
>>-----Original Message-----
>>From: owner-opencms-dev at www.opencms.org 
>>[mailto:owner-opencms-dev at www.opencms.org] On Behalf Of Bart Elberg
>>Sent: Thursday, October 31, 2002 8:40 PM
>>To: opencms-dev at opencms.org
>>Subject: [opencms-dev] Managing database size
>>
>>
>>Since OpenCms keeps a history of all changes published, the 
>>database can 
>>grow significantly in size with usage.  I would like to flush some of 
>>the unnecessary data from the database.  Is there a way to delete 
>>history records prior to a specific date from the database? (after 
>>backing it up, of course)
>>
>>Thanks in advance,
>>
>>Bart Elberg
>>__________________________________________________
>>I.D.E.A.L. Technology Corporation - Orlando Office 
>>
>http://www.idealcorp.com - 407.999.9870 x15
>
>
>
>
>

-- 
Bart Elberg
Manager of Software Development
__________________________________________________
I.D.E.A.L. Technology Corporation - Orlando Office
http://www.idealcorp.com - 407.999.9870 x15