22845 Posts in 9589 Topics by 2801 members
|Go to End|
13 June 2009 at 10:42am
Firstly I should say I'm a newbie.....
I've had SS set up for a while by someone else on for my site and think its great.
I have a 'big 105mb' problem though and looking for SS wizards advise please
Heres the problem:
I moved hosting because my old host was showing ever increasing connection errors.
I found a new host to move to.
Downloaded my site via ftp
Uploaded to the new host.
The my sql data base is 105mb's and the vast majority of it is old ip addresses and mountains of other useless info.
can someone tell me how to clean it up and stop silverstripe collecting all this data ( i'm presuming SS is the hoarder of this info?)
I'm not far off a computer dummy so please can you reply as if you are talking to a complete jerk, that way I might just understand.
13 June 2009 at 11:11am
What version of SilverStripe are you running? Versions prior to 2.3 where storing a lot of data in the "PageView" Table for the "Site-Statistics" module. Do you have access to your Database through a tool like "phpMyAdmin"? If yes, you could simply go there and "empty" (or truncate" the PageView table. No worries, you can safely do this as it won't have any impact on your site (just the stats, if you were using these at all).
13 June 2009 at 11:14am
Logged in and seen running 2.2.1.
can you tell me how to upgrade and will my site be safe if I do upgrade?
thanks again, I can see some light at the end of the tunnel now.
14 June 2009 at 1:43am
Take a look at the upgrade tutorial :
If you upgrade, you will benefit from the newer features of the silverstripe cms.
14 June 2009 at 10:21am
Yeah, you should be safe when you update. Nevertheless I strongly encourage you to create a backup of your existing Site (all files and a DB snapshot)!
The upgrading won't lessen the data used by silverstripe though. You would still have to empty/truncate or even delete the "PageView" table to decrease your DB-size.
14 June 2009 at 9:42pm
If you dont want the site statistics (and they arent all too useful anyway) you can empty the PageView table. Once you do that it should make it more managable. If you do not want to upgrade to 2.3 you can just turn off the statistics logging by editing the ContentController? file I think there is a static function in the init() statement in that file which logs all the page views (this was removed from 2.3 as it was a horrid way of doing the statistics section)
|Go to Top|