Re: Export SQL to cloud storage contains only table definitions, no data

Dear Joe,

I have come across this post a couple times looking to a solution to export data from Cloud SQL.

The purpose is to change the database from one project to another, both Google.

Is there any export solution including data - or another way to transfer data from one to another Cloud SQL project?

Your help would be greatly appreciated.

Regards,

DIrk

On Wednesday, August 28, 2013 1:30:41 AM UTC+9, Joe Faith wrote:

Hi Ralph

We're currently working on improving connectivity.

I've sent you an email off-thread about this.

J

On Tue, Aug 27, 2013 at 5:29 AM, Ralph Brecheisen <ralph.br...@arcus-business.com> wrote:

Hi,

We're using Google Cloud SQL for a hour registration tool. This tool is being used regularly by about 40 users so we need a good strategy for making changes to the database. It surprised us somewhat that the google_sql.sh tool allows you to upload a SQL file but not export and download one. After looking into the documentation I saw that Google Cloud Storage is the preferred medium of exchange. This is fine for us except for the fact that the SQL file exported from Cloud SQL does not contain the actual records, only the table DROP/CREATE statements.

Is there a special option or configuration setting that I have to set in order to let the dump contain the records as well? Or am I missing something else? Maybe there's some error being produced under the hood but I don't have access to the lower level logs as far as I know. The operations log in the cloud console just reports that the export went fine. 

It's really problematic for us that we're not able to download a copy of the database so any help would be greatly appreciated. 

Thanks!

Ralph

--
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/4c0c533e-ae0e-4aa1-99e5-46dda4032d2c%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
Joe Faith | Product Manager | Google Cloud

--
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/3684b8ca-cdc3-4a34-b276-d3442df93be9%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.