Migrate data from SQLite to MySQL

Configuration
1

Hi there,

I want to stop using SQLite backend, and start using MySQL.

Is there any documentation for migrating the existing data ?

Thanks,

2 Likes
2

This might be out of the scope of HA and more a MySQL question.
However to point you in the right direction MySQL have a tool called MySQL Workbench which should help you along.

https://www.mysql.com/products/workbench/migrate/

Unless you have a specific reason to import all the existing data though I would recommend just starting with an new blank MySQL DB.

3

I‘m looking for a bullet-proof, up to date (meaning HA 2021.12 release) guide on how to migrate all data from SQLite to MariaDB/MySQL database.

Maybe someone can guide on an up to date, proven guide.

It’s almost unbelievable, but I couldn’t find one searching the whole forum.