Skip to content

quel/mysql2postgres

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

25 Commits
 
 
 
 

Repository files navigation

Tool for converting mysql database to postgresql.
It can create postgresql dump from mysql database or directly load data from mysql to
postgresql (at about 100 000 records per minute).

It can translate now most data types and indexes, but if you experience some problems, feel free
to contact me, I'll help you.


Stronly required help to make params of databases not hardcoded.



After launching tool, You can see something like..

Loading invites: ....*.. 7046 (0min 1s)
Loading looks: . 1455 (0min 1s)
Loading message_stats: ....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*... 113627 (0min 10s)
Loading messages: ....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*....*.. 472456 (2min 25s)
Loading metadata: ....*...



Point (.) means, that 1000 of records have been read from MySQL. 
Star (*) means, that 5000 of records have been dumped into PostgreSQL (closeinput has been called).

About

Mysqldump, writing in postgresql format

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published