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

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.