Cleaning series_data

[Frédéric Buclin]

Le 30. 07. 10 10:26, Jochen Wiedmann a écrit :
> Is it possible to purge this data before the migration and run
> "collectstats.pl --regenerate" afterwards?

collectstats.pl --regenerate will only regenerate data for old charts,
not data for new charts. So you would loose a lot of data if you purge
the series_data table. I'm surprised it takes so long for the conversion
as this table mostly contains integers. Not sure what's the best thing
to do, though.

Maybe you could store the series_data table elsewhere, upgrade your DB
with an empty series_data table, then copy the content of the copied
table into the upgraded (and empty) one. As there is a series_date
column, there is no risk to conflict with new data which could be added
while you populate this table.


LpSolit