Monday, October 16, 2017

[google-cloud-sql-discuss] Re: Export from MySQL to csv and then import from the same file alters data

The problem is that SELECT ... INTO OUTFILE can export only to a local file on SQL server and this is obviously disabled for Cloud SQL instances - I get "access denied". Currently I have to export via web interface, replace escaped char with sed which is prone to errors and then load with LOAD DATA LOCAL INFILE. 

--
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/83a770f4-6b6c-4ec7-8227-115aa5a5bfd0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment