MYSQL Replication But While the backup is being uploaded to the slave, the changes in the master are not received
0
votes
0
answers
35
views
I am trying to do mysql replication. But I want to while the backup is being uploaded to the slave server, the changes in the master are not received.
For example:
I have a user table on my X db. And 1000 user records.
When I run:
my.cnf of the Master DB
mysqldump -u root -p --all-databases --master-data=2 --single-transaction --flush-logs --delete-master-logs --triggers --routines --events > master_data.sql
master_data.sql is have 1000 user records.
Then I added 200 user record my master db. Now my Master DB has 1200 user records, but my backup has 1000 records.
When I run:
mysql -u root -p < /path/to/master_data.sql
Result:
MY slave DB has 1000 record. MY master DB has 1200 record. What can I do.
my.cnf of the Slave DB


Asked by İbrahim Gunes
Jul 12, 2024, 08:00 PM
Last activity: Jul 13, 2024, 12:24 AM
Last activity: Jul 13, 2024, 12:24 AM