Two steps to complete mysql database replication

This article mainly tells you about two steps to complete mysql database replication. You can check the relevant professional terms on the Internet or find some related books to supplement them. We will not dabble here. Let's go straight to the topic. I hope that this article can bring some practical help to you.

1. First create a new database

Create database mydatabase default character set utf8mb4

two。 Copy tables from the source database to the new database

Mysqldump-h 172.17.0.12 sourcedatabase-u username-p password-- add-drop-table | mysql-h 172.17.0.12 mydatabase-u username-p password

Two-step completion of mysql database replication will first tell you here, for other related issues you want to know can continue to pay attention to our industry information. Our section will capture some industry news and professional knowledge to share with you every day.