Re: [google-cloud-sql-discuss] Re: Can not import from storage

When you perform the export, you should specify the databases you want to export.

The issue stems from the fact that the export you have tries to perform DDL changes on the mysql database which we do not allow. 

Alternatively, edit your existing export to remove any statements that modify the mysql database.

On Fri, Nov 18, 2016 at 1:01 PM Rohit Manglik <rohit.manglik@gmail.com> wrote:

Hi,

I am also getting same error. Is there any workaround for this problem?

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

I am having a down time because of this error.

Any lead?

On Tuesday, 9 August 2016 22:09:12 UTC+5:30, James McManus wrote:

When I attempt to import a file using the console, to cloud sql, from storage I get the following message when I "Browse" for the file:

Object not available. Either it does not exist or you do not have access. Try browsing for the object instead.

I've done this many times before and have not had this problem. I've tried changing permissions on the file, in storage, but have the same problem. I can also can download the file, directly using a url, so I do not think the problem is with storage. 

If I change the path, to the file, in the cloud sql import "Browse" console to:

danudata/danunews%2F2016%2Flatest_news_feed080916.csv

I no longer get the error message, but it then fails to import the data.

This appears to be a problem with google sql import console. Has anybody else had this problem? Are there solutions?

Thanks

Jim

--
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/ccd228e7-95d4-454f-90e2-91cd34c40998%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CABDU3p3HJEwfViLtudu4yegW8G3NbqGTmGXr-T89Ypdj0nZ8Tw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.