"[08/11/2021] [Restore of mysqldump during ingestion fails with ROW_FORMAT issue]" #8
Description
** Expected Behavior**
dSource creation process should execute seamlessly when the user provides the mysqldump path
** Actual Behavior**
The restore step of dSource creation process failed with incompatible ROW_FORMAT issue
Steps To Reproduce the Problem
On source MySQL create database tables with ROW_FORMAT as 'FIXED'. Its supported in older versions of MySQL so we need to first install MySQL version that supports FIXED and then upgrade same installation to 5.7. Also ensure the stage is 5.7 or later that doesn't support FIXED.
When we create a dSource making the Source as Master and Stage as slave, the restore process fails with incompatible ROW_FORMAT (e.g. FIXED) on Slave
Steps to reproduce the behavior:
- Go to '...'
- Click on '....'
- Scroll down to '....'
- See error
Screenshots
If applicable, add screenshots to help explain your problem.
Version
MySQL 5.7
Additional Context
We may need to reformat the rows or remove the row_format using sed command and then restore on stage