Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Dtabase clean upDtabase clean up
Previous
 
Next
New Post
4/1/2010 2:42 PM
 

Good Afternoon.

My site database have 200MB from godaddy. They can not even increase the size even I want to pay more. Is there any way that I can add the second datbaase to the site so when one database is  full dnn take second database auto. As I have unlimited database

Any other option for it

Thanks

Kundan

 

Any ot

 
New Post
4/1/2010 3:13 PM
 

You can have individual modules access different databases, but generally all modules and DNN functionality exists in one database. You could also simply point DNN to an external database server if you want to backup your database from Godaddy and restore it elsewhere, though that will likely lead to a decrease in performance.


Chris Hammond
dnnCHAT.com a chat room for DotNetNuke discussions
Christoc.com Software Solutions DotNetNuke Module Development, Upgrades and consulting.
 
New Post
4/1/2010 5:08 PM
 

Kundan,

You may want to clear out some of the data in the database.. for example, do you know which table is taking up the most room?  The events log can hold a lot of data, so you may want to clear this table by signing on as Host and going to the Admin>Event Viewer and selecting clear log

You can use the following t-sql commands to view the table sizes. It will list the table in size order -- largest first.   Use the Host>SQL to execute

set nocount on

-- create table to hold name and rows
-- cannot use in-memory as it will not work with sp_MSforeachtable
Create table #dnntables (
 tablename varchar(64),
 tablerows int
)

  declare @rows int
 declare @sql varchar(1000)

-- load table with names
-- undocumented MS stored proc -- well documented on Google
exec sp_MSforeachtable  'insert into #dnntables(tablename) values( ''?'')'

-- create cursor to load rows count into table
declare tabcursor cursor read_only
for select tablename from #dnntables

declare @Tablename varchar(64)

open tabcursor

fetch next from tabcursor into @TableName
while (@@fetch_status <> -1)
  begin
   set @sql = 'update #dnntables '
   set @sql = @sql + 'set tablerows = (select count(*) from ' + @TableName + ')'
   set @sql = @sql + 'where tablename = ''' + @TableName + ''''
  
   --print @sql     -- uncomment to see generated update command
 
   exec (@sql)      -- note: must enclose in brackets to executed string

 fetch next from tabcursor into @TableName
  end

-- dump collected data
--Select * from #dnntables
Select * from #dnntables where Tablerows > 0 order by TableRows desc

-- clean up
close tabcursor
deallocate tabcursor

drop table #dnntables

Hope this helps
Paul.

 
New Post
4/1/2010 7:04 PM
 
usually start clearing Eventlog, sitelog, schedulHistory and search tables reduces sice by more than 90% for most installations.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals

Speed up your DNN Websites with TurboDNN
 
New Post
4/1/2010 7:25 PM
 

You may use the following:

Clear search tables (Not sure up to what DNN version it is good):

delete SearchItemWordPosition where SearchItemWordId in (select SearchItemWordId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem)) 
delete SearchWord where SearchWordsId in (select SearchWordsId from SearchItemWord where SearchItemID in (select SearchItemId from SearchItem)) 
delete SearchItemWord where SearchItemId in (select SearchItemId from SearchItem) delete SearchItem 

 

Clear eventlog

TRUNCATE TABLE eventlog

Clear Site Log

TRUNCATE TABLE sitelog

 

 

 


Yehuda Tiram
AtarimTR
AtarimTR
972-2-5700114   |   972-54-4525492   |    http://www.atarimtr.co.il
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Dtabase clean upDtabase clean up


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Copyright 2014 by DNN Corp | Terms of Use | Privacy | Design by Parker Moore Design