Mysql master-slave server, master database build table slave database not Synchronize

Master and Slave built by mysql5.6, the newly created table is not backed up to the slave library
master and slvae data can both correspond to

clipboard.png

clipboard.png

can"t the test library be automatically backed up to the slave library when establishing a master-slave?

test libraries manually added during testing

Feb.27,2021

has been solved. You need to have the same database, and Synchronize will only start from the currently set synchronization point. Before, the data needs to be migrated


if the master-slave relationship is established correctly, a new table will be created in the master database, which will transfer Synchronize to the slave database. The master-slave library I built is like this.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bdb904-31286.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bdb904-31286.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?