php - 如何自动将数据库从本地主机上传到服务器？

Question

我的软件数据库在本地主机的 MySQL 中，另一个数据库在服务器上。如何将 loaclhost 同步到服务器数据库？当我的 PC 连接到互联网时，我想在我的软件中添加功能，从本地主机自动更新服务器数据库中的数据

Answer 1

使用Replication

Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

Replication is asynchronous - slaves need not be connected permanently to receive updates from the master. This means that updates can occur over long-distance connections and even over temporary or intermittent connections such as a dial-up service. Depending on the configuration, you can replicate all databases, selected databases, or even selected tables within a database.