Page 1 of 1

Migration from SQLite to MariaDB

Posted: 19 Feb 2025, 15:13
by SP5MTD
Hi, I started logging my QSOs using SQLite, but now considering switching to MariaDB, so I can access my data
a from different computers.

Is it as simple as exporting all logged QSOs to ADIF files, connecting to MariaDB and importing saved ADIFs into new database?

Configuration is not dependent on database? shall I just copy AppData/Roaming/Log4OM directory?

Re: Migration from SQLite to MariaDB

Posted: 19 Feb 2025, 15:22
by G4POP
Why bother?

I have been accessing a common SQLITE database for 10 years from 3 PC's using Google Drive or Dropbox

Why not check the user manual and this forum by searching on word 'Dropbox'

Unless your running several contest stations at the same time or have over 120K QSO's MySql is not needed

Re: Migration from SQLite to MariaDB

Posted: 19 Feb 2025, 15:31
by SP5MTD
I do not like to use cloud services, I have good backup for my self-hosted MariaDB and also my own VPN access. I consider such a setup independent and more future proof.

Re: Migration from SQLite to MariaDB

Posted: 19 Feb 2025, 17:45
by G4POP
Your choice

Re: Migration from SQLite to MariaDB

Posted: 19 Feb 2025, 18:02
by SP5MTD
I know :). So any idea if exporting / importing logged QSOs as ADIFs is the way to go? Will I get full data into new DB?

Re: Migration from SQLite to MariaDB

Posted: 19 Feb 2025, 19:25
by G4POP
SP5MTD wrote: 19 Feb 2025, 18:02 I know :). So any idea if exporting / importing logged QSOs as ADIFs is the way to go? Will I get full data into new DB?
Just follow the instructions in the user guide

Re: Migration from SQLite to MariaDB

Posted: 20 Feb 2025, 08:25
by SP5MTD
G4POP wrote: 19 Feb 2025, 19:25 Just follow the instructions in the user guide
There is no instruction in the user guide for database migrations, a least I didn’t find any. My gut feeling is that ADIF export / import should to the job. The only doubt is if I cover all data that way.