[google-cloud-sql-discuss] Unable to migrate to Cloud SQL because of lack of ability to skip replication errors. Much needed feature.

I have made 4 attempts thus far in migrating my DB from an external server to GCloud SQL 2nd Gen but have failed every time. 

The mysqldump process was successfully completed. Close to 2TB data was successfully imported into the cloud and the replication process successfully started. However, for some reason or the other, would get a 1062 duplicate error. I couldn't figure a way to skip it because of the lack of a SUPER privilege. I know those errors can be ignored but I'm not allowed to set any variable to tell the replication to skip 1062 errors. 

I would then just make another attempt, re-dumping the DB (it takes a few days cos of the size), then again resuming replication, only to face the same issue just before it can reach the final sync.

I need some solution to figure this out, quite tired of trying from scratch every time, this gone on for a few weeks and wasted bills as well.

--
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/5a7d6fa4-058f-49b9-ac6f-e5f27de02d7a%40googlegroups.com.