How do you save data to SQLite coming from MySQL database?

Question

A step-by-step tutorial..

Answer 1

I am not experienced in using SQLite, but maybe you can try to dump MySQL data into a .sql file then import it from within SQLite. That is if SQLite supports importing data from a .sql file.

Good luck 👍

Answer 2

Follow this toturial to create a sqlite3 dB file.
https://www.sqlite.org/quickstart.html
Then use PHP to create table and data.
Create 2 database connections to perform the data replication.

Answer 3

I think you would have to open two database connections simultaneously.
Below article is not really detailed but may start you in the right direction.
https://nixmash.com/post/simultaneous-mysql-and-postgresql-data-connections-in-java
Also this:
https://stackoverflow.com/questions/10593647/how-to-create-multiple-database-connections-for-different-databases-in-java