[Solved]: Database backup [Solved]: Database backup
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

[Solved]: Database backup

Started by jacci, March 12, 2008, 01:49:09 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jacci

Was downloading my database today and noticed the hit_stats table had hit the 20mb mark.

Having browsed it, found something like 4500 pages of individual hit statistics.

if i empty out this table, will it kill my total counts for files/albums/categories/comments/views etc ?

The individual stats themselves are of little interest to me, although the overall summary ones are and the 20mb dl is a huge file to keep backing up.

thanks
jacci

Nibbler

If you don't want the detailed stats then disable them in config. You can safely empty the stats table.

jacci

Thanks so much for that.

Wasn't really aware of that option in the config, and have now turned it off.

Am goign to empty that table now and should make backing up much easier.

thanks again.
jacci