Migrate from MySQL Database to PostgresSQL Database
Loads data from the MySQL database, transforms it to PostgreSQL compatible format and uploads it to the PostgreSQL database. Note - it requires pgloader to be installed and both PostgreSQL and MySQL hosts are accessible from the machine running this script.
Authored by: Dipak ParmarBrought to you by Warp, a free terminal reimagined to work like a modern app.
mysql_username
mysql_password
mysql_hostname
mysql_port
mysql_database_name
postgres_username
postgres_password
postgres_hostname
postgres_port
postgres_database_name
Command
Copy
pgloader mysql://mysql_username:mysql_password@mysql_hostname:3306/mysql_database_name postgresql://postgres_username:postgres_password@postgres_hostname:5432/postgres_database_nameTags
Edit in GitHub
Copied