Wednesday, January 15, 2020

[google-cloud-sql-discuss] Re: I have no idea how to resovled this problem when I tried to restore a MySQL database

Hey there,I have watched this link

https://stackoverflow.com/questions/39221261/triggers-cloud-sql-2nd-generation

and even I have set log_bin_trust_function_creators to be on within the flag confgiuare on the MySQL instance configuration,but it doesn' work as well

On Wednesday, January 15, 2020 at 1:52:55 AM UTC+8, Aref Amiri (Cloud Platform Support) wrote:
This error occurs when you try to import a file that contains elements that cannot be imported into Cloud SQL. Your exported file might include DEFINER clauses, that means that it contains one or more triggers, views, or stored procedures. I would suggest following the instruction provided here to avoid such errors.

--
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/315ef842-c252-41c9-be57-4f3960e8de3d%40googlegroups.com.

No comments:

Post a Comment