
Product
Socket Now Protects the Chrome Extension Ecosystem
Socket is launching experimental protection for Chrome extensions, scanning for malware and risky permissions to prevent silent supply chain attacks.
Copy rows from MySQL to PostgreSQL quickly.
export PGHOST=localhost
export PGUSER=postgres
export MYSQL_DATABASE=example
export MYSQL_HOST=127.0.0.1
export MYSQL_USER=root
docker run -d -e MYSQL_ALLOW_EMPTY_PASSWORD=true -e MYSQL_DATABASE -p 3306:3306 --name mysql --rm mysql
mysql -D "$MYSQL_DATABASE" -u "$MYSQL_USER" <<EOF
CREATE TABLE example (a int, b text);
INSERT INTO example (a, b) VALUES (1, 'a'), (2, 'b'), (3, 'c');
EOF
docker run -d -e POSTGRES_HOST_AUTH_METHOD=trust -p 5432:5432 --name postgres --rm postgres
psql <<EOF
CREATE TABLE example (a int, b text);
EOF
mysql2pg
psql <<EOF
TABLE example;
EOF
docker stop mysql
docker stop postgres
INFO Found 1 tables
INFO Truncating 1 tables
INFO Copying table example
INFO Copied 3 rows to table example (0.00s)
a | b
---+---
1 | a
2 | b
3 | c
(3 rows)
pip3 install mysql2pg
Mysql2pg copies records from MySQL tables to existing PostgreSQL tables.
Mysql2pg also resets sequences, based on the maximum column value.
Performance is limited by network bandwidth, database resources, record size, and parallelism. In anecdotal usage, performance is 1m+ records/min serially.
usage: mysql2pg [-h] [--log-level {critical,error,warning,info,debug}] [--parallelism PARALLELISM]
[--pg-search-path PG_SEARCH_PATH]
[tables ...]
Copy records from MySQL to PostgreSQL
positional arguments:
tables
options:
-h, --help show this help message and exit
--log-level {critical,error,warning,info,debug}
--parallelism PARALLELISM
Number of tables to process in parallel (default: 10)
--pg-search-path PG_SEARCH_PATH
PostgreSQL search path (default: None)
MySQL tables are discovered.
PostgreSQL tables are truncated.
PostgreSQL triggers (including foreign keys) are disabled.
Records are streamed from MySQL and uploaded to PostgreSQL via the COPY command.
Sequences are discovered and reset based on the maximum value in the column.
Tables are processed in parallel.
FAQs
Copy data from MySQL to PostgreSQL
We found that mysql2pg demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Product
Socket is launching experimental protection for Chrome extensions, scanning for malware and risky permissions to prevent silent supply chain attacks.
Product
Add secure dependency scanning to Claude Desktop with Socket MCP, a one-click extension that keeps your coding conversations safe from malicious packages.
Product
Socket now supports Scala and Kotlin, bringing AI-powered threat detection to JVM projects with easy manifest generation and fast, accurate scans.