How can I set a local replication of my company's my SQL server.

See more:

PHP

Apache

MySQL

I'm working with a health care company as an administrator our team made software based on php and hosted in local server. Now we plans central purchasing and the main center will remain as warehouse. But the problem is this last week mysql corrupted and I sit back and restored the database from dump file. We are not confident on data while connecting our server with other branches. How can I make a replica of database in another system so as to keep a backup system if main system failed permanently

What I have tried:

How can I set a local replica of my company's My SQL server? I tried coding but it's difficult