How to transfer an entire database over TCP?

Question

MySQL

There is a server written in Java and working with MySQL. And there is an android application that has a SQLite database.
How to transfer the entire database (3 tables, 4 fields each) from the server to androyd via tcp connection?
And how, having received it, to bring it into the SQLite database?

Answer 1

Well so you do 2 connections to a DB - internal and external.
Next, drag the data with a select and insert / update the local one.
Close the external connection.
Of course, in reality it is somewhat more complicated, but you understand the logic.