MySQL 8.0 master standby replication

[Kaushal Shriyan]

Hi,

I am setting up MySQL 8.0.31 DB Master and Standby replication on two separate servers. How do I replicate the existing Database which is already present on the Master MySQL DB server?

For example,

Master MySQL DB server

mysql> show databases;
applicationproddb
mysql
testdb
mysql>

MySQL Master Standby Replication is configured.

mysql> create database testproddb;
mysql> show databases;
applicationproddb
mysql
testdb
testproddb
mysql>

Standby MySQL DB server
mysql>
testproddb
mysql>


When I create any database in Master it gets replicated to slave but the existing database, for example, the existing database applicationproddb is not getting replicated.

Please guide.

Thanks in advance.

Best Regards,

Kaushal