Incorrect Import of database with views

[GoogleCodeExporter]

I have a local mysql 5.5 database that I have worked on for quite a while.  It 
has some view tables.  When I load it to cloud sql via a sqldump file, the 
import went through no errors, but I can't query any of the views, from my GAE 
app nor from the web console.  I get access denied error on select statements.  
Selects on tables are fine.  

1. Create a sqldump file from my local mysql database with views, and upload it 
to the Cloud Storage.
2. Import it to the Cloud SQL database via Google Cloud Storage
3. Open the Google Cloud Console and run a select statement against one f the 
views.

What is the name of your database instance?

Instance Id: neptune-1:dev-1.  Database: team2.

What is the expected output? What do you see instead?

select * from {view_new}

should return results, but I get an accessed denied error.

Please provide any additional information below.

The same mysqldump loads ok with my local databases.

For the time being I create a script to drop the views and recreate them after 
the import.

Original issue reported on code.google.com by yxzhao...@gmail.com on 17 Oct 2013 at 12:22

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

We have not been able to reproduce the issue which you have described. We 
recommend that you start a discussion on Stack Overflow about the problems you 
are seeing. If others are able to reproduce this issue, please open a new issue 
which links to this issue and any posts where it was reproduced so we can take 
another look.

Original comment by vshe...@google.com on 20 Apr 2015 at 7:05

• Removed labels: Restrict-View-EditIssue

[GoogleCodeExporter]

Hi,

I would like to know if you are still unable to import views that you have 
created on your local MySQL database. Please let me know so we can get our 
engineers to look into this.

Thank you

Original comment by vshe...@google.com on 21 Apr 2015 at 10:10