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

Forum

Reduce the database size
Last Post 2009-07-01 09:08 PM by Lee Sykes. 2 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
AnuPadduUser is Offline
Nuker
Nuker
Posts:19

--
2009-06-29 01:40 PM  
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

<!--Session data-->[script removed]
Joseph CraigUser is Online
DNN Creative Support
Nuke Master VI
Nuke Master VI
Posts:9309
Avatar

--
2009-06-29 06: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 DNNCreative
I recommend PowerDNN for DotNetNuke Hosting.
Lee SykesUser is Offline
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:4945
Avatar

--
2009-07-01 09: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/DNNCreative

Lee Sykes's Facebook Profile
You are not authorized to post a reply.

Active Forums 4.3

Latest Forum Posts

DNN 6.2 by Sameer
Hi All i am using dnn 6.2 beta version for my demo site i need to custmize the 4 modules in that
RE: Deploying dnn by Sameer
Thanks a lot so kind of you
RE: Unable to Create Skin Package by schilders
Joe, When I click the Edit icon next to the skin package on the Host Extensions page, I receive t
horizontal main and submenu items by Dan Glanton
I found a very good tutorial on horizontal main and subitems in DNN Creative, but what about if you
RE: Skin creation - Menu questoni by Joseph Craig
This has to do with the structure of the elements that make up the skin and the CSS. Most likely, y
Skin creation - Menu questoni by CDMeyer
I have a skin and when I add more menu items to the nav bar than can fit in one row of nav, the seco
RE: FCK Editor in DNN 6 by Pingle2009
Just to follow on from Joe's reply, the 'official' line seems to be that not only that the old FCK E
RE: Slice a Site by Dan Glanton
Thanks, I'll look into that when I get a chance.
RE: Creating structured page content by Stephen Bugden
Thankyou very much Joe, I will take a look at your suggestions.
RE: Subpages or dropdowns navigation is going behind this flash by Joseph Craig
I googled a bit and found that this is a messy problem. Possibly the best solution will be to giv
RE: Subpages or dropdowns navigation is going behind this flash by vijendra
Pls check the attachment. That Iframe code we are using and subnavigations are goind behind that.
RE: Rename or move site from domain name to subdomain name by Bill Quinn
Hi Joseph, Thank you so much for your reply. I will be able to implement this later in the we
RE: Creating structured page content by Joseph Craig
Take a look at the DotNetNuke Reports Module, the DotNetNuke Form & List Module, SGSV from Tresslewo
RE: Subpages or dropdowns navigation is going behind this flash by Joseph Craig
It looks like your iframed content may have a z-index that puts it on top of the menu. I can't id
Subpages or dropdowns navigation is going behind this flash by vijendra
Hi, Subpages or dropdowns navigation is going behind this flash. Pls check the url below http://www.
RE: user adding images by rod lloyd
That worked, thank you. I did not expect those permissions to be in File Manager. I note a
RE: Unable to Create Skin Package by Joseph Craig
To be quite honest, I've never used this functionality to create a skin. What I usually do is cre
RE: Unable to Create Skin Package by Joseph Craig
I'm confused by this, too.
RE: Unable to Create Skin Package by schilders
We are running DNN 6.x
RE: Unable to Create Skin Package by Joseph Craig
Which version of DotNetNuke are you using?
You are not logged in.
You must log in to access all 
650+ videos, tutorials, podcasts, and more.
RSS Feeds