There are several operations listed here. The first one we see
is the execution of the mysqldbexport
utility to create a file that includes an export of all
databases as designated with the
--all option. We add the
'--export=both' option to ensure we include the definitions as
well as the data.
We also add the
which instructs mysqldbexport to generate
the replication commands with respect to the source server
being the master. Lastly, we include the replication user and
password to be included in the CHANGE MASTER command.
Next, we see an attempt to run the import using mysqldbimport but we see there is an error. The reason for the error is the mysqldbimport utility detected a possible problem on the slave whereby there were global transaction identifiers (GTIDs) recorded from the master. You can see this situation if you setup replication prior to running the import. The way to resolve the problem is to run the RESET MASTER command on the slave as shown in the next operation.
The next operation is a rerun of the import and in this case it succeeds. We see a warning that is issued any time there are replication commands detected in the input stream whenever GTIDs are enabled.