Moving from mySQL to PHPFINA with a twist or two

Tags: #<Tag:0x00007f6e02c71150> #<Tag:0x00007f6e02c71088> #<Tag:0x00007f6e02c70fc0>

I currently have EMONCMS (9.8.31) running on a low power x86 system using mySQL.

I now want to use EMONCMS on RPI 3B+ using PHPFINA.

I noticed there was a couple of similar threads on this topic here and here.

I had assumed there would be a bulk csv import tool, but it doesn’t look like it. It appears there options for using NodeRed to do an import, but I don’t know that it would be suitable for 60 million records I have with over 40 feeds.

It might be possible to use the (Moving from mySQL to PHPFINA), but I am concerned about the limited processing power of the x86 system. I am also not sure if this script would still work. Have there been any changes in the last two and half years that might cause a problem?

Any thoughts or suggestions would be appreciated.