[rtg] Rtg 0.8.x and some problem with 0.7.4

[Atle Veka]

On Wed, 28 Jun 2006, Rudy Setiawan wrote:

> And another question, hmm since the db is quite big, I want to know what
> kind of backup can I do? So maybe I can take anything out that is from April
> to May and leave June intact. Then maybe store into another db called
> rtg_year, to create a yearly graph? Hehe any suggestion?

Here's one way you can do it: Set up a replicated mysql slave (even on the
same host if you want to), replicating your RTG data. Then you can do data
pruning on your master dataset while keeping historical data intact:
	master> SET SQL_BIN_LOG=0;
	master> DELETE FROM <table> WHERE <datefield> < DATE_SUB( NOW(),
		INTERVAL 1 MONTH );

Just from the top of my head, I think that's how the SQL stuff would
work.. Let me know if you want more details.


Thanks,

Atle
-
Flying Crocodile Inc, Unix Systems Administrator