Hello everyone,
I am currently trying to import a mysqldump (~60GB), which includes stored procedures and triggers, to my google cloud sql instance.
I have paid attention to the docs and have set log_bin_trust_function_creators
to true using terraform.
I have included the triggers and stored procedures in the dump but removed the DEFINER with perl because its not supported.
I tried using the gcloud sql import function and the web console to import the dump from a storage bucket, each time the following error pops up after a couple seconds:
severity: "ERROR"
textPayload: "2018-06-26T10:48:42.727799Z 87406 [Warning] Using unique_checks=0 which is non deterministic!"
As far as I know unique_checks is set during dumping to speed up the import afterwards.
I would like to avoid doing the dump again(60GB you know..).
Does anyone know what this error means and how I can fix this? Can it be fixed with a new dump?
Please let me know if there is anything wrong with my question, this is my first time posting here.
Best regards,
Max