Move from Sqlite to MariaDB: can i throw events and states tables?

Configuration
1

Hi to all!
I want to migrate from Sqlite3 to MariaDB. Sqlite3 now is about 2gb, 'cause has last 3 months of stats and giants table events and states.

So, I want to mantain my stats. Is it sufficient to move that “statistics___” table and can I throw events and states tables?

Thank you

2

Not really sure how HA will react if some tables are in Mariadb.
I would suggest:

  • make a copy of the sqlite db and work on that one to be able to rollback
  • empty the events and state tables
  • export and import in MariaDB.