I see many users have migrated to MySQL. Because of the performance boost, but especially when using a Raspberry Pi with an SD card, it is more reliable too.
It would be great if there is an official tool to migrate from SQLite of MySQL. The current migration requires being comfortable with CLI, regex, etc.
I agree we really need a tool, but for now i created a tutorial whats a bit easier to use.
I created the tutorial (i have myself 0 knowledge of sql), i just did read the full thread and some other answers, so i tried to simplify the way to migrate, and a couple of people did DM me to thank that this tutorial does work and not causing any data loss.
No regex needed, only 2x use of the CLI