Search code examples
linuxubuntu-14.04postgresql-9.3mysql-5.6

datetime error while transferring from mysql to postgres using mysql2pgsql


While transferring data from MySQL to Postgres using mysql2pgsql I am getting the following error

Exception: unknown datetime(6)

I am using ubuntu 14.04, Mysql5.6 and Postgres9.3


Solution

  • What version of mysql2pgsql are you using? Does your version include the fix for this issue? Is the traceback (found in logs) similar?