将我的本地数据库(Mysql)复制到远程数据库(phpmyadmin) [英] Replicate my local database (Mysql) to remote database( phpmyadmin)

问题描述

我的MySQL数据库(本地服务器)已连接到气象站.数据在我的本地服务器上不断更新.我的想法是开发一个允许我访问此数据的Web应用程序. 我的本地数据库(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:

我的问题是: 1-我该如何连接?我知道我可以手动导入我的cvs文件，但是我不想这样做. 2-我可以在我的远程服务器中自动更新数据吗?

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 ?

注意:我只想在我的远程服务器(phpmyadmin)上查询，我不会创建或修改新数据. 谢谢您的帮助.

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

推荐答案

据我了解，您想在远程服务器上复制本地mysql数据.

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

首先 phpmyadmin 是访问mysql的工具或Web应用程序，它本身不是服务器.

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

第二

有两种复制方法

• 主从(从从读取，写入到主，将同步到从) 如何做到
• Master- Master(无论在Masster上进行的任何操作，都将在其他Master上复制)

• 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

Master-Master与Master-slave数据库体系结构?

如何实现复制

http://dev.mysql.com/doc/refman/5.7/en/replication-howto.html

这篇关于将我的本地数据库(Mysql)复制到远程数据库(phpmyadmin)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！