mysql把本地数据库数据复制到远程,将我的本地数据库（Mysql）复制到远程数据库（phpmyadmin）...

My MySQL database (local server) is connected to a weather station. The data are updated continuously on my local server. My idea is to develop a web application that allows me to access this data.

My local database (MySQL) has to be replicated on a remote server (phpmyadmin)

The architecture is as follows:

My questions are:

1- How I do the connection ? I know that I can import my cvs file manually but I don't want to do this.

2- Can I update the datas automatically in my remote server ?

NOTE: I only want to queries on my remote server (phpmyadmin), I will not create or modify new datas.

Thanks you for your help.

解决方案

As i understood, you want to make a copy of your local mysql data on a remote server.

first of all phpmyadmin is a tool or webapp to access mysql , it is not a server itself.

and second

there are two type of replication approach

Master-slave (read from slave , write to master, that will sync to slave)

How to do it

Master- Master (whatever operation are on masster that will also replicate on other master) How to do it

You can choose the approach as per your requirement

How to achieve replication