I was able to get my database structure edits, etc... done by creating some extra 'tool' type queries in my python website app and re-deploying, so no worries. basically i just used my website app to do the things i was hoping to do with a mysql client... but oh well.
On Wednesday, July 8, 2015 at 1:04:11 PM UTC-5, Jason Andrea wrote: > > ahhhh.... yes. it is IPv4. So now I've had Google generate an IPv4 IP > 'allowable IP' for me... which makes perfect sense. I've updated all of my > connection info with the new IPv4 IP that Google assigned me. But still not > connecting. But now it is taking much longer before it gives me basically > the same error. > > I wish i could see my database show up somewhere on one of Google's > consoles. This whole thing is just odd to me. I'm looking at my project, > and looking at the "databases" tab, but it doesn't list any databases (see > attached screen shot). > > Even when i simply try to "Export" my data using the export button at the > top.... it always throws an error because it can't find the database. > > Here is my python code: > #google cloud sql database connection info > #production database > GOOGLE_DATABASE="shpotrades" > > I can't even get confirmation from Google that I actually DO have a > database named 'shpotrades'. Yet my site is working and showing the data. > Lord God Google.... WHERE IS MY DATA? :) > > Thanks for your help, Ryan... you are the man. > > > > On Wednesday, July 8, 2015 at 12:13:57 PM UTC-5, Ryan (Cloud Platform > Support) wrote: >> >> The IP address for your PC that you authorised. Is it a IPv4 or IPv6 >> address? >> >> On Tuesday, July 7, 2015 at 4:48:21 PM UTC-4, Jason Andrea wrote: >>> >>> So, one of the reasons i only developed 1 or 2 apps using GAE was >>> because i was unhappy with the console interfaces (aside from all of the >>> other tools required to even get started) and the time it takes to learn >>> them, get comfortable with them etc... and back when i created my 1 or 2 >>> apps, the consoles, menus, etc... seemed to change ever few weeks. Granted, >>> this was a few years ago. But now i have to do some data maintenance on >>> one of my GAE websites that, thankfully, is still working just fine. I have >>> a Cloud MySql database behind my website. People can register information >>> about their businesses, etc... and have other people on the web search it. >>> All is working fine, but now i need to simply dump the data in the MySql db >>> AND make a small change to one of the fields in a MySql table. >>> >>> Back before i abandoned GAE, i could easily go to >>> https://appengine.google.com, find the data viewing console and type in >>> queries, and actually SEE my MySql data behind my site. Now... my old >>> documentation is completely defunct, with links all redirecting to new >>> locations, because the google console interfaces have changed so >>> drastically since I was last on the site, and i can't seem to find anything >>> even remotely close to a console screen where i can select the database i >>> want to query (like in the old days) and type into a text box to run some >>> queries or update my schema. >>> >>> Basically... i know my data is there because people are adding to it >>> every day... and the data is findable on the website itself, but i can't >>> for the life of me find a way to connect/view my data on the >>> https://appengine.google.com or https://console.developers.google.com >>> sites. Does anybody have any advice? >>> >>> In my Python app settings.py code I have my: >>> GOOGLE_APPINSTANCE_NAME >>> GOOGLE_DATABASE_NAME >>> >>> I'm also wondering if i can connect to this data via my desktop Navicat >>> MySql client. >>> >>> Do i really have to do all this? >>> https://cloud.google.com/sql/docs/mysql-client >>> >>> And do I have to create a MySql instance/IP if I alerady HAVE a MySql >>> instance running out on GAE? My website is obviously using the MySql data >>> behind it from when i first built the site. Why can I not find my MySql >>> data via the Google Console(s)? >>> >>> >>> -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-appengine+unsubscr...@googlegroups.com. To post to this group, send email to google-appengine@googlegroups.com. Visit this group at http://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/1b2562b0-aace-4cb4-b38c-7873c139393d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
