How to synchronize local database with remote?

Question

MySQL

Hello!
Such a task: on a computer (one), the operator drives data into a table. The Internet
is not always available on this computer. But if there is a connection, the local table must be synchronized
with the remote table. At the other end (manager), the data does not change, only for viewing, i.e.
synchronization in one direction (from the operator to the manager) is quite enough .
As I did now: for the operator I made a small program in Delphi, with an sqlite file,
I placed this file in Dropbox, I made a web interface for the manager, so that all sorts of selections by date, etc.
Question: what other options, preferably with a MySQL database? Because sqlite does not have a date field type, and you have to bother
with date conversion and sorting

Answer 1

Obviously you need replication

Answer 2

Date - easily changed to bigint, save Epoch time

Answer 3

How to synchronize local database with remote?

Use only remote, as you do. To improve, find a cloud that allows you to create a database in yourself, and not just store files.