Databse getting really big what can I do about it?

[GenT]

Hello,

I have been using UTstats for quite some time now and the database i getting very big. Its now 614 MB. And i do not have that mutch space left on the server.

Is it possible to delte the oldest stats or do I have to reinitialize the database completely. Starting with a clean one.

Hope there is a easy solution.

greetz,

[Panther]

Please read for support.

[GenT]

Please read for support.

Its really not a problem with my operating system or anything..just a short and I think easy question.. And you did help others with easy questions without posting this .

Butt anyways here goes:

UTStatsDB version: utstatsdb-3.01 (I know old version butt again it runs and I have no problems with this version)
Operating system and version: Linux (donno what version... Butt again not the problem, because UTstats does run fine...)
Database type and version: MySQL versie 5.0.45
PHP version: PHP versie 5.2.4
Web server and version: ?? (No idea what you mean. Again it all works and I guess its standerd??)

Can i delete some things in the ut_gevents table? are these the parsed logs? And they start with match 1 all the way to 120.000 and more.. And also perhaps the ut_gscores table? These 2 are the biggest tables in the database.

[Panther]

For one thing different versions of UTStatsDB are configured differently.
Simply set "Max Matches" in your main config options to how many matches you want to keep and UTStatsDB will remove all older matches.

[GenT]

OK thank you found it, and works great thanks again