Monday, September 9, 2013

Re: Importing data from .csv file

Thanks Ram -- hopefully others will find it useful

We also hope to make this process easier soon

j




On Mon, Sep 9, 2013 at 3:37 AM, Ram Nathaniel <ram.nathaniel@gmail.com> wrote:
This is what you do: (took me a while to find out)

1) install mysql locally on your computer, with the workbench (don't need the utilities)
2) create a local table and import the CSV into it.
3) export to a file
4) Go to google cloud storage and create a bucket (a folder), then put the dump file in it.
5) import into google cloud sql from the bucket.

It took me some time to figure this out (google help was not helpful at all!). Maybe their search engine will bring this in search results for others.

If it helped you, than add:
6) when you figure out something after a long search - write a post so others can google it :-)

Ram

--
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/f4c06a81-a2c5-44ed-9ef1-a2064a8362e8%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/CAHNz2%3D-qN6dsfST0q%2B74Z4E_A1pg6tiUzkuwjY0xCke8k%3D80Ww%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

No comments:

Post a Comment