This repository has been archived by the owner on Jun 30, 2021. It is now read-only.
forked from maxlapshin/mysql2postgres
-
Notifications
You must be signed in to change notification settings - Fork 1
alexeychr/mysql2postgres
This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
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. After editing config.yml and launching tool, You can see something like.. Creating table friendships... Created table friendships Loading friendships... 620000 of 638779 rows loaded. [ETA: 2010/01/21 21:32 (00h:00m:01s)] 638779 rows loaded in 1min 3s Indexing table friendships... Indexed table friendships Table creation 0 min, loading 1 min, indexing 0 min, total 1 min # note from mgkimsal I'm still having trouble with bit(1)/boolean fields workaround I've found is to put output in file then in VIM on file, search/replace the true/false binary fields with t/f specifically (reversed on 3/23 - should be ^A gets f) :%s/^@/t/g :%s/^A/f/g keystrokes are ctrl-v ctrl-shift-@ to get the 'true' binary field keystrokes are ctrl-v ctrl-shift-A to get the 'false' binary field
About
Mysqldump, writing in postgresql format
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published