Thursday, April 13, 2017

[google-cloud-sql-discuss] Re: How to migrate data from MySQL database to PostgreSQL database?

Hello Aleksander,

This is not something that is supported, however there is information publicly available that would offer some tips to be able to do this.

// Instructions for importing data into CloudSQL postgres
https://cloud.google.com/sql/docs/postgres/import-export/importing

// wikibook for converting a mysqldump output file to a postgres compatible dump file
https://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL

// mysql docs regarding the --compatible flag
https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_compatible


Alexis
CloudSQL Team




On Thursday, April 13, 2017 at 6:12:24 AM UTC-7, Aleksander Efremov wrote:
Through script `GET` - `INSERT`? There is a tables with 2 million rows and more.

--
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/177a4efd-1e39-4b80-a806-69ec99bdb1b5%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment