Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Migrate database from Postgres to MySQL [closed]

Tags:

database

mysql

postgresql

I have changed database from postgresql to mysql, but I don't know how to transfer data from one to other.

Does anyone know any command by which I can copy/migrate my database from postgresql to mysql?

like image 618
Sachin R Avatar asked May 06 '11 09:05

Sachin R

People also ask

Will PostgreSQL overtake MySQL?

PostgreSQL is still catching up to MySQL's popularity, which means that fewer developers are working with it and fewer third-party applications are available. However, with the increasing need for highly concurrent services that are always available, Postgres might soon overtake MySQL as the most popular database tool.

2 Answers

Faced the problem a few years ago, and used pg2mysql

EDIT 21 july 2019 : this fork seems a better option (patches, light maintenance)

like image 94
Frosty Z Avatar answered Oct 13 '22 03:10

Frosty Z

You can use the MySQL Workbench which can import from a variety of database types, including Postgres.

like image 19
Deckard Avatar answered Oct 13 '22 04:10

Deckard
Sign in to Comment

Related questions

Get last distinct set of records
MySQL 1062 - Duplicate entry '0' for key 'PRIMARY'
Python 3.4.0 with MySQL database
Causes of MySQL error 2014 Cannot execute queries while other unbuffered queries are active
Create an ActiveRecord database table with no :id column?
Maximum concurrent connections to MySQL
SELECT INTO and "Undeclared variable" error
PHP: maximum execution time when importing .SQL data file
MySql difference between two timestamps in days?
Laravel Database Schema, Nullable Foreign
Illegal mix of collations error in MySql
MySQL combine two columns and add into a new column
Mysql Error:The user specified as a definer ('mysql.infoschema'@'localhost') does not exist' when trying to dump tablespaces
How to select domain name from email address
Inserting and selecting UUIDs as binary(16)
The best way to get the first and last day of last month?
MySQL explain Query understanding
PRIMARY KEY definition in MySQL CREATE TABLE statement
MySQL: "= true" vs "is true" on BOOLEAN. When is it advisable to use which one? And Which one is vendor independent?
MySQL Order before Group by

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!