one off
no from late 2016 early 2017
Could you update the local Card? Is there a reason not to?
What version of EmonCMS on the local instance?
As you are doing some structural changes, it might be a good opportunity to do this migration. The Sync module is installed by default on the newer version.
Iām equally not sure if Sync will pull in mysql feeds but I suspect it will, though whether it will convert to a different storage engine is another unknown to me.
@TrystanLea, could you chime in here?
The sync module is only compatible with phpfina and phptimeseries feeds. Either a mysqldump or a direct copy of the mysql folders (e.g if mysqldump is too large/slow) is likely the easiest way to copy the data across.
Itās worth noting thought that mysql feed data is not optimised for low write load and so will likely wear the SD card faster, if you are using an SD card?
Thereās an old archived script for converting mysql feed data to phptimeseries here: usefulscripts/sql_to_phptimeseries_mv.php at master Ā· emoncms/usefulscripts Ā· GitHub but its not something Iāve touched for many years and is archived so may not work.
1 Like
i did some manual work to port data and settings but i screwed up a bit
some of the phpfina tables got mixed up, are there also scripts that can convert mysql to phpfina?
would get me half the way
then i would just need the reverse of
Iāll predicate this by saying Iām no expert in the data storage @TrystanLea is your man for that.
The documentation is here https://learn.openenergymonitor.org/electricity-monitoring/timeseries/History
I think that you canāt as PHPFINA is a fixed time slot, no average (FI = Fixed, NA = No Average) storage and the SQL is a variable time storage thus can be converted to a timeseries store.
1 Like
If memory serves, thatās Fixed Interval No Average.
1 Like
Couldnāt work out what the I was 
1 Like
Hey, nice to see you using the
