database - how to migrate data from mySQL to PostgreSQL -

trying migrate database mysql postgresql. documentation have read covers, in great detail, how migrate structure. have found little documentation on migrating data.

i want migration using transport tablespace, have tools migratin, or know how migrate using transport tablespace mysql postgresql

i have 104 table in mysql , 200 mb data

i not sure, can migrate using transport tablespace mysql postgresql.
in order migrate big data sets can use postgresql copy.

generally, better use program, automates process of migration (db structure , data). here few open source tools, can helpful:

frommysqltopostgresql feature-reach tool , easy use.
it maps data-types, migrates constraints, indexes, pks , fks in mysql db.
under hood uses postgresql copy, data transfer fast.
frommysqltopostgresql written in php (>= 5.4).

pgloader   data loading tool postgresql, using copy command. main advantage on using

copy

or

\copy

, , on using foreign data wrapper, transaction behaviour, pgloader keep separate file of rejected data, continue trying copy data in database. default postgresql behaviour transactional, means erroneous line in input data (file or remote database) stop entire bulk load table. pgloader implements data reformatting, typical example of being transformation of mysql datestamps 0000-00-00 , 0000-00-00 00:00:00 postgresql

null

value (because our calendar never had year zero).
pgloader written in lisp , distributed source code, you need compile before using.

hope you...