MySQL Bugs: #100409: MySQLWorkbench data migration fails during bulk data transfer

Bug #100409	MySQLWorkbench data migration fails during bulk data transfer
Submitted:	1 Aug 2020 21:20	Modified:	31 Aug 2020 12:35
Reporter:	Michael Yazdani	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: Migration	Severity:	S2 (Serious)
Version:	8.0	OS:	MacOS (10.15.6)
Assigned to:		CPU Architecture:	x86

Description:
During data migration from a single MySQL instance running on a VPS, to a MySQL cluster hosted and managed by DigitalOcean, the migration assistant proceeds fine until bulk data transfer. Upon beginning "Copy data to target RDBMS", I get the following info and errors (actual hostname replaced with 'target-host'):

17:11:01 [INF][      copytable]: Logger set to level 'debug3'. '1111111'

17:11:01 [INF][      copytable]: Connecting to MySQL server at target-host:50245 with user doadmin

17:12:17 [ERR][      copytable]: Failed opening connection to MySQL: Can't connect to MySQL server on 'target-host' (60)

17:12:17 [ERR][      copytable]: Exception: mysql_real_connect: Can't connect to MySQL server on 'target-host' (60)

How to repeat:
1: Begin data migration, using SSH tunnel to connect to both source and target
2: follow steps in migration assistant, pulling schema from source and copying schema to target
3: begin bulk data transfer

Corrected CPU arch from ARM to x86

Hello Michael Yazdani,

Thank you for the report.
The migration process does not support source or target RDBMS connections through SSH.
A workaround is to set up an encrypted tunnel, and then treat the MySQL target as a standard TCP (unencrypted) connection. More information is available at https://dev.mysql.com/doc/workbench/en/wb-migration-install.html 

Regards,
Ashwini Patil

Bug #103198 marked as duplicate of this one.