The "safeness" of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based format. To require statement-based format, you may choose to set the binlog_format system variables used with binary logging to "MIXED". When MIXED is specified, statement-based replication is used. You may gather more detail from the "7.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging" online documentation page. Performing a new dumping operation with this parameter set as described would represent one of the ways to address your issue. It would take considerable more effort to recover the same information from a inadequately performed dump, than starting correctly from the beginning.
-- You may also consider setting the unique_checks system variable at session level.
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/f155104d-8263-4fe9-9e62-ef68e87ecdb9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment