MySQL Forums
Forum List  »  Install & Repo

Master data not present in mysqldump output
Posted by: Frank Worker
Date: January 07, 2024 07:45PM

In my first outing with MySQL 8.0.30, I'm looking to do seed a replication on a slave using a dump from the master. The master doesn't yet have any data in the tables. By way of experience, my first inclination was to use "--master-data=2" in the command, which now because "--source-data=2".

What I wasn't prepared for is that there's nothing in the output that came from mysqldump that includes the "show master status" equivalent.

The command I'm using is:
mysqldump --skip-lock-tables --single-transaction --flush-logs --hex-blob --source-data=2

Is the absence of any data why the master status is not included?

The "show master status" presents this:
mysql> show master status\G
*************************** 1. row ***************************
File: mysql-primary-0-bin.000005
Position: 14352
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.00 sec)

The mysqldump output doesn't include either "change source" or "change replication" or anything that references the master or the above file/position. The above command syntax has worked for me with MySQL/MariaDB previously without issue.

For reference, MySQL is being used inside of OpenShift.

Options: ReplyQuote


Subject
Written By
Posted
Master data not present in mysqldump output
January 07, 2024 07:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.