Groups
Sign in
Groups
Google Cloud SQL discuss
Conversations
About
Send feedback
Help
How to migrate data from MySQL database to PostgreSQL database?
193 views
Skip to first unread message
Aleksander Efremov
unread,
Apr 13, 2017, 9:12:24 AM
4/13/17
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Google Cloud SQL discuss
Through script `GET` - `INSERT`? There is a tables with 2 million rows and more.
Alexis Guajardo
unread,
Apr 13, 2017, 5:00:41 PM
4/13/17
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Google Cloud SQL discuss
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
Aleksander Efremov
unread,
Apr 14, 2017, 12:42:34 AM
4/14/17
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to Google Cloud SQL discuss
Thank you for information. I did it already through:
https://github.com/dimitri/pgloader
. Very fast.
пятница, 14 апреля 2017 г., 1:00:41 UTC+4 пользователь Alexis Guajardo написал:
Reply all
Reply to author
Forward
0 new messages