Home

Homeassistant Sqlite3 to mariaDB merger

Welcome to the ha2mariadb wiki!

Update to work with the new schema version 43 - 2024-04-17

💡💡This need to wipe all data in mariaDB to work💡💡

So if you have run on mariaDB for some time and want to merge some old sqlight3 DB and at the same time keep the data you have in mariadb, this wont work.

First:

Install mariaDB in homeassistant, use homeassistant as username and databasename and remember to open port 3306.

Start mariaDB

Install phpmyadmin and start phpmyadmin.

💡 Make sure you start with an complete empty DB in mariaDB else this wont work.

Go to phpmyadmin and make sure there is no data in the homeassistant DB

We can now move to linux, i use

Ubuntu: 📌

💡 mariadb-client cant download to Ubuntu Live-DVD so one cant use Live-DVD.

Windows:

If you dont have a machine with Linux, its possible to run Ubuntu in Windows. Ubuntu on Windows