Unhandled MySQL type 245 for column x
Posted by: Alexandru Busuioc
Date: February 11, 2019 09:35AM

I'm using a generated script (by MySQL Workbench) to migrate the data between 2 databases.
At some point I get

> ERROR:`users`.`user_details`:Unhandled MySQL type 245 for column 'address_info'
> ERROR:`users`.`user_details`:Failed copying 154 rows
> /usr/lib/mysql-workbench/wbcopytables: line 16: 23755 Segmentation fault (core dumped) $MWB_BINARIES_DIR/wbcopytables-bin "$@"

That `address_info` column is a JSON type.

Is there something I could do to avoid this error and succeed with the migration? Or `wbcopytables` doesn't support JSON data type just yet?

FTR

> $ wbcopytables --version
> wbcopytables-bin CE (GPL) 8.0.15 CE build 14271522

Thank you,

Alexandru

Options: ReplyQuote


Subject
Written By
Posted
Unhandled MySQL type 245 for column x
February 11, 2019 09:35AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.