I have no idea how to resovled this problem when I tried to restore a MySQL database

[asjdfkasjkf kasjfksjfk]

Hey guys ,I uploaded my database backup file which was a sql file to GCP storage,then I tried to import this backup file into the MySQL vm,after a while it occured ths exception

Import failed: Import error: exit status 1 ERROR 1227 (42000) at line 10871: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

it can't be resolved anyway though,it's impossible to grant super privilleges to any users in MySQL vm though

[Aref Amiri (Cloud Platform Support)]

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.

[asjdfkasjkf kasjfksjfk]

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

[asjdfkasjkf kasjfksjfk]

sorry for getting back you late,I apperciated

On Wednesday, January 15, 2020 at 1:52:55 AM UTC+8, Aref Amiri (Cloud Platform Support) wrote:

[Amit Sinha]

Hello,

Could you please try exporting the sql dump using the instruction here and then import it? As mentioned in the note “These instructions exclude all triggers, stored procedures, views, and functions from the export. This is needed to enable Cloud SQL to import the dump file. If your database relies on any of these elements, you must manually recreate them after importing.”

[asjdfkasjkf kasjfksjfk]

thanks for replying,I really appreciate it,I have resolved this problem

--
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-d...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/61209b84-9241-4e09-808b-fb098b210d50%40googlegroups.com.