How to transfer data automatically from one MySQL Database to another MySQL Database?

Question

I have two MySQL Database which are in different machines. I want to transfer data from one Server to another automatically. Lets say, I want my data transfer to happen each day morning 4:00.

Can it be done? Is there any MySQL built in feature by which we can do it?

I want to transfer data from some specific tables not from the whole DB.

Answer 1

If you want automated solution handled by MySQL, then it's replication what you need. Since the topic is broad and covered in detail in MySQL manual, I suggest you sit down and read what the documentation says on the topic.