Hi,
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.
but;
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.

Thanks!!!

Hi there

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).

Thanks Banal....

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. :-)

Take a look at the upgrade tutorial :
http://doc.silverstripe.org/doku.php?id=upgrading

If you upgrade, you will benefit from the newer features of the silverstripe cms.

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.

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)