Migrate back from MariaDB to the default SQLite

Well, without much hope I did so and it worked!

I was also surprised to see that this 2nd time around the size was much lower (670MB) than the first (1GB), but I think I know the reason.

The first time I migrated the original db back from my HA beginning was still there with a few months of data before I migrated to MariaDB. I manually had switched to that SQLite before and was happy to see the data was still there, so I was hoping the MariaDB data would get merged with that one. But that’s the one that got corrupted.

Is there I could I could manually recover the data from that date range that’s still there (in the 1st migration file)?

Edit: nvm, it’s too old data to bother.