[opencms-dev] Bloated database. How to delete rows fromcms_contents table?

[Jonathan Woods]

Laurent - there've been a few questions on the list recently which might
help:
 
http://www.nabble.com/forum/Search.jtp?forum=654
<http://www.nabble.com/forum/Search.jtp?forum=654&local=y&query=delete+histo
ry> &local=y&query=delete+history
 
They mostly concern the use of the Workplace admin interface to reduce the
amount of historical information retained.  As for removing records
directly, I'd be careful - not sure if constraints are enforced, and you
might end up corrupting stuff.
 
There's also Alkacon's commercial OCEE module, which (I believe) contains
more powerful OpenCs db management tools.
 
Jon


  _____  

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Laurent Gauthier
Sent: 10 July 2009 01:57
To: opencms-dev at opencms.org
Subject: [opencms-dev] Bloated database. How to delete rows fromcms_contents
table?



We use OpenCMS to store many large PDF files and we have been exporting and
importing content from one database to another. 

 

Problem is, the database size is growing at an alarming rate and taking up a
whole lot of space.  From what we can see, the "cms_contents" table appears
to be the main culprit.

 

Is there a way to get rid of old versions of documents  in the cms_contents
table?

 

We tried using the cmsshell command:

 

deleteBackups n

 

But this did not appear to have any effect. Should we go ahead and delete
records directly in the database (sounds scary).

 

Help of any kind appreciated.

 

Laurent

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20090710/2947341b/attachment.htm>