Migrating home assistant database from sqlite to mariadb.. ONLY if you are VERY familiar with Database administration

I remember some of my graphs were seriously messed up after clean import, but I haven’t noticed that immediately.

I have trouble with connecting to the MariaDB that the port number is not an integer

image

I did already some checks in the transporter.py from sqlite3mysql and the port number shows with type as <class ‘int’>

I am running phyton 3.10 on Ubuntu 22.04

Found the solution to solve all dependences, on the site source location from the tool GitHub - techouse/sqlite3-to-mysql: Transfer data from SQLite to MySQL there is the solution to use a docker container which contain the whole tooling.

1 Like

you may need to add in --break-system-packages when runinng “pip3 install sqlite3-to-mysql” command (i had to)