Syncing the local database content to a remote mySQL database

This section covers the Meteobridge PRO, PRO2, NANO SD, Raspberry Pi and VM platforms exclusively

Moderator: Mattk

Post Reply
Marko
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: Thu Apr 06, 2023 9:48 am

Syncing the local database content to a remote mySQL database

Post by Marko »

Hi,

is there a possibility to sync the local database to a remote mySQL database? I do not mean the usual push functionality where one basically builds a SQL statement that puts selected data into the remote database but a real "replication" of the local database.
Ideally such a replication keeps track of the last record successfully synced and catches up as soon as the remote database is online again (should it be offline some time). By the way, which database is actually used locally?

Thanks,
Marko
User avatar
admin
Platinum Boarder
Platinum Boarder
Posts: 7854
Joined: Mon Oct 01, 2007 10:51 pm

Re: Syncing the local database content to a remote mySQL database

Post by admin »

Meteobridge uses a sqlite3 database and I don't think there are methods of automatically having this replicated with another sqlite3 or even your preferred mySQL database. I think you are asking a bit to much from an embedded device :-)
Post Reply