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

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."


On Thursday, January 16, 2020 at 9:51:30 AM UTC-5, asjdfkasjkf kasjfksjfk wrote:

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:

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/61209b84-9241-4e09-808b-fb098b210d50%40googlegroups.com.