You need to Register for free and Login to post a message in the forum.

Forum

Subject: Reduce the database size
Prev Next
You are not authorized to post a reply.

Author Messages
AnuPaddu
Nuker
Nuker
Posts:19

29 Jun 2009 8:40 AM  
Hello,

I need to delete Event log details in database. Whether i can go and delete it straightly in the db. If it so it wont affect any other references? coz i need to reduce my database size. Any other ideas plzzz

Thanks,
AnuPaddu

[script removed]
Joseph Craig
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5144


29 Jun 2009 1:44 PM  
Use the SQL page under host, enter "Truncate Table EventLog," and then click Execute.

I also refer you to Mitchel Sellers blog (mitchelsellers.com) for discussion of this and also a module that automates some maintenance tasks.

Joe Craig
DNN Creative Support
Subscribe to the website
Lee Sykes
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5083


01 Jul 2009 4:08 PM  
you can set your scheduler to automatically delete old event logs. also in the event logs, you can set how many event logs should be kept, some of them are set to * unlimited, and you may want to change this to just 20 log entries.

We cover this in detail here:
Site logs, Event logs and Scheduler


Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > DotNetNuke® > Modules > Reduce the database size



ActiveForums 3.7

Latest Forum Posts

RE: query regarding page options by kaustav_kar
Thanks for your reply.Could you please let me know from where I can get the OWS module?Thanks
RE: How to Limit Access to Administrator Modules in DotNetNuke 5 - issue 50 by leesykes
Hello,Yes that's the only method I can see to make it work.Create a Tabs page - give edit permission...
RE: Uploading an MP3 file to my website by leesykes
If you are going to be uploading a lot of large MP3 files you may find it is best to use FTP, make a...
RE: Custom Textbox Size by leesykes
I can't see an easy way to do this with a standard text box, I've tried CSS styling the id and can't...
RE: query regarding page options by leesykes
hello,If you do not wish your visitors to login, then I think the only other option will be to use c...
Localizing Skins and css dynamically based on language selected by sadabahar83
Hi, I want to dynamically assign a skin and CSS based on the language selected. Different pag...
Recomended DNN version? by lolorn
What version of DNN would be recommended for creating a new site? Has DNN 5.2 turned out to be as st...
query regarding page options by kaustav_kar
Hi,My site will have two Home pages, one for a new visitor and one for a returning visitor.   Is the...
RE: Plz Help. Page_Load_Exception by zaidkhan
URL of My website is www.pafkiet.edu.pk
Few new skins by Rozo
Skins for DNN and other CMS. www.stelg.com
RE: Plz Help. Page_Load_Exception by jncraig
Can you provide a URL?
RE: Custom Textbox Size by jncraig
For the second part, you can switch the editor to source mode and enter unstyled text. For the fi...
RE: Picture size limits by jncraig
The little red x's generally mean that the link to the image is broken.  My guess is that you have a...
RE: Uploading an MP3 file to my website by jncraig
web.config is in the root directory of your DotNetNuke installation.  ALWAYS (!!) make a backup copy...
RE: Customizing registration page by kana
Ok, thank You for answers. I'll try to make it with OWS. Marek
Picture size limits by Doug_s
I'm lost - I've just changed host and a few thing that used to work don't, plus I can't display anyt...
RE: How to Limit Access to Administrator Modules in DotNetNuke 5 - issue 50 by samjst
Hi, Did you manage to solve the problem? I'm facing the same issue: users with access to add and...
Ealo Tab Localization help by sadabahar83
hi, I have installed Ealo Core Api and Ealo tab localization and ealo Menu provider. menu is wor...
Custom Textbox Size by PopeOMalley
Hello everyone,Do you know if there is a way to customize the size of a textbox control on the Manag...
RE: DotNetMushroom RAD by md-pv
That sounds interessting too. I'll check it. Thanks a lot.
DNM Rapid Application Developer Trial Version
RSS Feeds