Importing data from .csv file

[Abhishek Mathur]

Hi everyone,

Is there any way to import data in cloud sql instance table using .csv file?
Importing data this way to individual tables help me getting my data to case sensitive cloud sql instance from my local case-sensitive
mysql server.

--Thanks,
Abhishek

[Abhishek Mathur]

OOPs!!! I made a typo in hurry. my local mysql server is "case-insensitive".  :)

[Ram Nathaniel]

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

[Joe Faith]

Thanks Ram -- hopefully others will find it useful

We also hope to make this process easier soon

j

--
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-d...@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