PostgreSQL to MySQL Error
Posted by: David Pardoe
Date: June 24, 2017 03:54AM

I am trying to migrate a database in PostgreSQL into MySQL using the migration wizard. Issue is that it is failing for a couple of tables seemingly down to some bad data. Error message below:

ERROR: `dashboard`.`consultant_consultant_table`:Inserting Data: Incorrect string value: '\xE1lez' for column 'name' at row 54
ERROR: `dashboard`.`consultant_consultant_table`:Failed copying 11869 rows

Is there a way I can get the migration to ignore bad data and replace with NULL for the "bad" rows? - I am certain most of the rows are fine. The error causes the table load to stop.

Alternatively is there a way I can get the migration to ignore the bad fields (I do not need them in the migrated database)?

Options: ReplyQuote

Written By
PostgreSQL to MySQL Error
June 24, 2017 03:54AM

Sorry, you can't reply to this topic. It has been closed.

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.