[SOLVED] Source data type [geometry] not supported

Source data type [geometry] not supported

I am using Navicat Premium to Migrate my Data from Postgresql to Mysql.

I am facing a strang error while migration. It says that Migration is not possible due to Geometry object not available.

I am pasting the logs here..

[Msg] [Dtf] DataTransfer started
[Msg] [Dtf] Getting tables properties
[Msg] [Dtf] Getting tables fields
[Msg] [Dtf] Getting tables constraints
[Msg] [Dtf] Getting tables indexes
[Msg] [Dtf] Getting total records count
[Msg] [Dtf] Drop table: `geom_data`
[Err] [Dtf] 80120001: Source data type [geometry] not supported
[Err] [Dtf] Finished - Unsuccessfully
--------------------------------------------------

What could be the problem.. Can I migrate Postgresql Spatial data to MySql?? Any alternative? Any way out??

Solution

The Task can be done through SQLyog's data Migration wizard.

SQLYog-->Powertools-->Import External Data-->Start A new Job-->

After that select Any ODBC Source from the radio Buttons
Select File DSN---> Create a New DSN--File Data Source-->PostgreSQL Unicode
Click Next and save the file anywhere. eg abc.dsn
Click next and enter postgresql details and click finish
Enter the MySql database details you wanna copy your data into.
You are ready to go.

Hope it helps.!

Note: If Postgresql contains geometrical data, please make sure that you are using MyISAM as the database engine in MySql. Also remove indexing on any geometrical element before copying.