Do changes in SQLite automatically get reflected in MySQL?

Question

I am new to using services. In my application I want to run services in the background. I am creating the same database in MySQL server and SQLite. If I change some data in a table in the SQLite database, does it mean it should automatically store the change in the MySQL-server also?

Answer 1

To answer your question: no, it does not automatically reflect the changes made in SQLite into MySQL.

Why? Because you basically have 2 different databases, although they have the same name (and probably structure). In order for them to communicate and get synchronized, you need to implement some kind of communicating mechanism.

As suggested to you by eggyal in an above comment, take a look here, as a solution for this kind of problem is explained there.