+ 3

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

A step-by-step tutorial..

11th Feb 2019, 6:42 AM
ariamossar
ariamossar - avatar
3 Réponses
+ 3
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 👍
11th Feb 2019, 9:30 AM
Ipang
+ 3
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.
11th Feb 2019, 10:18 AM
Calviղ
Calviղ - avatar
+ 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
12th Feb 2019, 5:51 AM
Tibor Santa
Tibor Santa - avatar