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

Hi folks,

The Cloud SQL team is working on the issue that Jim describes.

I believe that the issue Thomas describes is actually different.  I suggest you take a look at what line 14 of your import file actually says. You will likely find that it is a command that requires SUPER privilage, perhaps attempting to installing a plugin, or creating an event or trigger with a DEFINER set. You should be able to modify the import file not to have anything that requires SUPER privileges and it'll import. If you want to share the offending line I'll try and help.

David

On Wed, Aug 10, 2016 at 3:17 AM, Thomas Locke <thomas@relatelabs.com> wrote:

I'm also getting the exact same message via the portal, which is very frustrating. Not being able to import is having a detrimental effect on the business I'm working with.

Interestingly I've also been running automatic nightly db imports via the gcloud sdk for the last few months. The last successful import occurred on Friday the 5th August.   

The error I get from running the import via gcloud now is below;

ERROR: (gcloud.sql.instances.import) ERROR_RDBMS

This error usually points to some permission issues, however the permissions look to be correct and they were the same permissions that always worked pre August the 6th.

I actually think the issue is related to the mysql db user that GCP uses to perform the import. The error in the operation log would seem to confirm thi.s 

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

Regards,

Thomas

On Tuesday, August 9, 2016 at 5:39:12 PM UTC+1, 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/bc21d141-dcec-4c25-aa70-a591bc194534%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/CAJZK_bYF_%2BpH0TamsiaM_Fz%2BLvVvJQpDs5Eqt0%3DMbqqL%2Bpu9Vw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.