Move MariaDB History to Influx?

Configuration
1

Is there a way to import an SQL Dump of MariaDB into influx so I don’t lose my history? I’m wanting to revert back to the sqlite database and prefer to not lose history in the process.

This appears to be my only real path back to sqlite from MariaDB since I’m on HAOS and besides, my MariaDB is 5GB now so I would rather not have to move 5GB to sqlite only to have to purge it soon after, even if there is a good way to revert.

2

The proper way is (was) to push history to influxdb through the influxdb integration.
Not sure how long is your default purge setting for MySQL (default: 10 days), but probably not worth the hassle anyway.