Personally, I think if the backup mysqldump if belt - master - data confirm some good, also can restore plus - start - position - start - position==XXX XXX,
If, when the backup mysqldump without parameters, master - the reduction of data, how to confirm the log?

CodePudding user response:

Not only should also master - data -- single ws-transaction

CodePudding user response:

Q;
Such as perfect there is a table, and then there is a delete table in front of a binlog operation, this reduction is not dangerous

CodePudding user response:

reference 1st floor rucypli response:

should not only - master - data also - single ws-transaction can

With this backup should be the two shall be chosen

CodePudding user response:

refer to the second floor kimmy257 response:

q;
Such as perfect there is a table, and then there is a delete table in front of a binlog operation, this reduction is not dangerous

This not dangerous, since you recognition is to restore to the point, then the table should be deleted

CodePudding user response:

refer to the second floor kimmy257 response:

q;
Such as perfect there is a table, and then there is a delete table in front of a binlog operation, this reduction is not dangerous

Related to delete point was found in the log, restore log plus - stop - position=XXX can by the end of the delete action before,