Home：ALL Converter>INSERT INTO MySQL table SELECT FROM PostgreSQL table

INSERT INTO MySQL table SELECT FROM PostgreSQL table

Ask Time：2015-09-15T17:45:56         Author：mallik1055

Json Formatter

I have a Amazon Redshift table which runs on PostgreSQL.This table is updated everyday with user data in large numbers.

I have to run a CRON process to import some of the needed data from the table everyday into a different MySQL database . I work in PHP.Please assist me how I could achieve this programatically.

Author:mallik1055，eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/32582838/insert-into-mysql-table-select-from-postgresql-table
mastaBlasta :
You should export from Redshift to an S3 bucket using the UNLOAD command, then load that file (CSV is a good choice) into MySQL. This can all be done from a cron job. It is by far the fastest and safest way of doing it.\n\nhttp://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html\n\nP.S.\nRedshift does not really \"run on PostgresSQL\". Sure, Redshift was a fork of Postgres, but the two are completely different beasts. ",
2015-09-15T14:36:44

More about “INSERT INTO MySQL table SELECT FROM PostgreSQL table” related questions

热门文章热门文章

相关搜索

yy

网站导航

特色功能

软件已通过杀毒认证

软件已通过杀毒认证_转转大师PDF转换器

联系方式

转转大师扫我联系客服_转转大师PDF转换器

转转大师扫我联系客服

Copyright Reserved 2009- © AllConverter.Net