• Stars
    star
    703
  • Rank 62,714 (Top 2 %)
  • Language
    Ruby
  • License
    MIT License
  • Created over 15 years ago
  • Updated almost 4 years ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

Mysqldump, writing in postgresql format

mysql-to-postgres - MySQL to PostgreSQL Data Translation

Build Status Dependency Status

MRI or jruby supported. The minimum Ruby version supported in master branch is 2.1.7, and the next release will have the same requirement.

With a bit of a modified rails database.yml configuration, you can integrate mysql-to-postgresinto a project.

Installation

Currently failing, see #81...

Via RubyGems

gem install mysqltopostgres

From source

git clone https://github.com/maxlapshin/mysql2postgres.git
cd mysql2postgres
bundle install
gem build mysqltopostgres.gemspec
sudo gem install mysqltopostgres-0.3.1.gem

Sample Configuration

Configuration is written in YAML format and passed as the first argument on the command line.

default: &default
  adapter: jdbcpostgresql
  encoding: unicode
  pool: 4
  username: terrapotamus
  password: default
  host: 127.0.0.1

development: &development
  <<: *default
  database: default_development

test: &test
  <<: *default
  database: default_test

production: &production
  <<: *default
  database: default_production

mysql_data_source: &pii
  host: localhost
  port: 3306
  socket: /tmp/mysqld.sock
  username: username
  password: default
  database: awesome_possum

mysql2psql:
  mysql:
    <<: *pii

  destination:
    production:
      <<: *production
    test:
      <<: *test
    development:
      <<: *development

  tables:
  - countries
  - samples
  - universes
  - variable_groups
  - variables
  - sample_variables

  # If suppress_data is true, only the schema definition will be exported/migrated, and not the data
  suppress_data: false

  # If suppress_ddl is true, only the data will be exported/imported, and not the schema
  suppress_ddl: true

  # If force_truncate is true, forces a table truncate before table loading
  force_truncate: false

  preserve_order: true

  remove_dump_file: true

  dump_file_directory: /tmp

  report_status: json    # false, json, xml

  # If clear_schema is true, the public schema will be recreated before conversion
  # The import will fail if both clear_schema and suppress_ddl are true.
  clear_schema: false

Please note that the MySQL connection will be using socket in case the host is not defined (nil) or it is 'localhost'.

Testing

License

Licensed under the MIT license.

More Repositories

1

stockdb

Database for storing Stock Exchange quotes in erlang
Erlang
93
star
2

fix

http://fixprotocol.org/ implementation.
Erlang
75
star
3

gitty

Git access in erlang
Erlang
39
star
4

comet

Example comet server in erlang
JavaScript
30
star
5

parsexml

Simple DOM XML parser with convenient and very simple API
Erlang
29
star
6

csv_reader

Fast erlang csv reader
Erlang
26
star
7

io_libc

C
19
star
8

nfs3

NFS v3 client for erlang servers
Erlang
18
star
9

nmea

Ruby NMEA parser
C++
18
star
10

fpbenchmark

Benchmark of fp webservers http://maxim.livejournal.com/392358.html
JavaScript
15
star
11

kladr

KLADR is an open repository of all postal addresses in Russia. Exported in DBF, needs translation to Mysql
Ruby
15
star
12

graphic

Nitrogen graphics
Erlang
12
star
13

vkontakte

Erlang vkontakte binding
Erlang
12
star
14

record2ei

Generates erl_interface code to decode erlang record based on their spec
Erlang
12
star
15

timed_supervisor

Timed supervisor
11
star
16

exiv2

Ruby extension to Exiv2 library
Ruby
10
star
17

intersys

Intersystems CachΓ© driver
C
9
star
18

erack

Erlang Rack implementation
Erlang
8
star
19

postgresql_complex_types

Support for extended features of postgresql, like arrays, complex types, etc
Ruby
8
star
20

erl_notify

C
7
star
21

MacCamera

Working with camera experiments
Objective-C
6
star
22

ipgeobase

Loader of ipgeobase
Ruby
6
star
23

stockdb-hs

Try to create stock database reader in haskell
Haskell
3
star
24

orbit

Ruby orbit library
C
2
star
25

car-arduino

Firmware for Arduino to control my radio car
2
star
26

l4t2-demo

HTML
2
star
27

redmine_grack

Redmine plugin that offers authentication/authorization support for grack
Ruby
1
star