Sunday, September 25, 2016

[google-cloud-sql-discuss] Errors when importing gen 1 v5.6 into gen 2 v5.6


ERROR 1227 (42000) at line 156: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Even after setting log-bin-trust-function-creators I still cannot import a simple dump from gen 1 to gen 2. Both v5.6.

How to reproduce:
  1. create a db on gen 1 v5.6 with a simple trigger on a table.
  2. export the gen 1 database to file X
  3. import file X into gen 2 v5.6 (o v5.7, I tried both) with and without log-bin-trust-function-creators - errors out with above message.
Note that you can import and export this file all day long without errors in gen 1.

All operations performed from the browser.

Any ideas on how to get around this?

--
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/53a1fd2a-6743-45d0-93a2-77243adb1d99%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment